View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jillybean jillybean is offline
external usenet poster
 
Posts: 1
Default Pivot Table Hide Zero Subtotals - Excel 2007

Is there a way to hide zero subtotals in a pivot table in 2007?

Say I have CustNumb, Part, PartNum, Sum of Net Sales in my Pivot table.
And say CustNumb 34567 has detail lines But his Sum of Net Sales Subtotal is
zero.

I don't want to see CustNumb 34567 or any other customer with a SubTotal of
Zero because the file is huge and the zero subtotals just add to the
confusion.

thanks in advance for your help.