I never try to manipulate data in pivot tables. Too much isn't allowed.

I would just copy the entire table using Paste Special, Paste Values. Then
you end up with a copy of the pivot table that you CAN manipulate.

"The Cherub" wrote:

I am trying to get a pivot table that will perform three of the stock
operations (sum, count and average) on the same data set, and have the
results as three different rows.

I have had a play around with Calculated Fields, and whilst I can add them,
I cannot change the Field Setting (greyed out).

Is there any way around this?