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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove subtotal where only one item
You could hide the subtotals with conditional formatting:
In the pivot table, enable Selection Select the field's subtotals Choose FormatConditional Formatting From the first dropdown, choose Formula is In the formula box, type a formula that refers to the cell above the active cell, e.g.: =$A8<"" Click the Format button, and select a font colour to match the cell background Click OK, click OK Biff wrote: 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 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove subtotal where only one item
Debra,
Thanks for the advise. Hiding the subtotals is a good compromise, but I wish there were an option to enable "smart subtotals." Thanks again, Dave |
Reply |
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 |