Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Headings for Sum in Pivot Table.
Month Gross Consumble Custom Clearing Battery
Apr-05 3187 3187 0 0 0 Apr-05 44779 0 300 44479 0 May-05 18900 0 18900 0 0 May-05 13087 0 0 0 13087 Jun-05 9900 0 0 0 9900 Jun-05 29856 0 29856 0 0 If I Insert Pivot table & select Month as Row label & Select Gross, Consumables, Custom etc as sum Values, the column heading shows "Sum of Gross", "Sum of Consumables". Is there any facility to design the column heading without the words"Sum of" & retain the original headings in the pivot table. This will help me to copy the pivot table values.? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Headings in Pivot Table | Excel Discussion (Misc queries) | |||
Make manually changed pivot table column headings work for other u | Excel Worksheet Functions | |||
Excel 2002: Can Pivot Table show headings beside the row labels ? | Excel Discussion (Misc queries) | |||
elucidating grouped headings in pivot table | Excel Discussion (Misc queries) | |||
pivot table row vs column headings | Excel Worksheet Functions |