Pivot Table names

  • Thread starter Thread starter john.menken
  • Start date Start date
J

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.
 
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.
 
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.
 
Back
Top