Pivot Table names

[john.menken]

I have a pivot table and after some manipulation it is giving me what
I desire. One question: is it possible to get rid of all the titles
that start with "Sum of" and replace it with something else? Thank you.

 

[Bob Phillips]

Right-click the field heading and select Field Settings, you can change it
there. If you want to change Sum of Amt say to Amt, add a space at the end,
else you will get a duplicate name error.

 

[Shane Devenshire]

Hi,

Click on the field button for "Sum of..." in the pivot table and type.
Can't use a name of an existing field but most other things are legal.

Works for all the field buttons in pivot tables.