Hello,
I have a PivotTable with a bunch of prices. I would like to organize the data into bands, so Band A - 'Eveything Below $10' and Band B - 'Everything above $10'. In my Calculated Field, how do I do - =IF('Price'<10,"Band A","Band B").
Example Data:
Product|Price
Car|5
House|20
Thanks,
Sharp
Bookmarks