Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove subtotal where only one item
Is there a simple way to format a pivot table such that when there is
only one item to subtotal, the subtotaling is deactivated? In other words, given a specific field, I _do_ want subtotals to show if there is more than one item and _do not_ want subtotals to show if there is only one item color size quantity blue 1 10 blue 2 15 blue total 25 red 1 13 red total 13 <- not necessary for this case, can it be removed? Thanks, Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal To Include Item Description On Subtotal Line | Excel Discussion (Misc queries) | |||
How to hide an item subtotal in the row field? | Excel Discussion (Misc queries) | |||
Removing a subtotal from an insert item in a pivot table | Excel Discussion (Misc queries) | |||
how do i remove the item from clipboard? | New Users to Excel | |||
Remove item from combobox. | Excel Programming |