Pivot table heading

M

molsansk

When I create a pivot table and the row from my initial table is for example
"Dec 2006", when I pull it into the pivot table it will make the heading "Sum
of Dec 06". Is there a way I can change the default so it just says my
original heading "Dec 2006" without the "sum of".

I know I can go in and change it individually, but I'd like to not have to
do that because sometimes I have to do this for a lot of columns and it is
time consuming to go in and change each one. I'm looking to change it so it
doesn't add the extra text to what I already have.

Thanks.
 
D

Dave Peterson

Select the range and Edit|Replace?


When I create a pivot table and the row from my initial table is for example
"Dec 2006", when I pull it into the pivot table it will make the heading "Sum
of Dec 06". Is there a way I can change the default so it just says my
original heading "Dec 2006" without the "sum of".

I know I can go in and change it individually, but I'd like to not have to
do that because sometimes I have to do this for a lot of columns and it is
time consuming to go in and change each one. I'm looking to change it so it
doesn't add the extra text to what I already have.

Thanks.
Click to expand...
 
Top