View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Biff[_2_] Biff[_2_] is offline
external usenet poster
 
Posts: 2
Default 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