Hi Guys,

Got a pivot table where I've added in a calculated field (it's an if formula to allocate a customer to a group) but now i'd like to create a chart from this (most probably a pie chart) showing how many customers are in each group. But I can't seem to move the calculated field in to a position to show this. Is there any way to successfully do this?

The only way i've worked out so far is by making a pivot of the pivot, which is obviously less than desirable..

Any help is greatly appreciated

Thanks very much.