Remove subtotal where only one item

[Biff]

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]

You could hide the subtotals with conditional formatting:

In the pivot table, enable Selection
Select the field's subtotals
Choose Format>Conditional 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]

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