Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding one subtotal in a pivot table
Is it possible to hide just one of the subtotals in a pivot table? I want to
see the subtotals for my Number of customers, Quantity, and Amount. But I do not need to see the subtotal for the % column I have, as it is always 100%. If not I can always fill in that one row and use it as a way to break apart the shop sections of the pivot table. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding one subtotal in a pivot table
Mark,
You should be able to double click on the name/label of each item which is usually in grey, then there are radio buttons with choices for subtotals or not for that item. Barbara "MarkM" wrote in message ... Is it possible to hide just one of the subtotals in a pivot table? I want to see the subtotals for my Number of customers, Quantity, and Amount. But I do not need to see the subtotal for the % column I have, as it is always 100%. If not I can always fill in that one row and use it as a way to break apart the shop sections of the pivot table. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Subtotal in a pivot table | Excel Discussion (Misc queries) | |||
Subtotal vs Pivot table - or best way | Excel Discussion (Misc queries) | |||
subtotal - pivot table - or better function | Excel Worksheet Functions | |||
pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) |