Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table heading
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table heading
Select the range and Edit|Replace?
molsansk wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel |