Pivot Table Hide Zero Subtotals - Excel 2007

[jillybean]

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.

 

[Shane Devenshire]

Hi,

Open a filter in the Row Labels area and choose Value Filters, Does Not
Equal and enter 0. See if that does what you want.

 

[jillybean via OfficeKB.com]

Thanks for your reply but I'm sorry to report that doesn't work.
My rows do not contain values.
The only value is in the sum values area.

I even tried to make my values a row and filter on that. But that doesn't
work because it is not the detail I want to hide it is the subtotal.

In other words I may have 15 lines of detail in the sum value area for one
customer number that are both positive and negative but the subtotal is zero.
I want to hide all of it if the subtotal is zero.

Any other ideas would be appreciated.

 

[Herbert Seidenberg]

Excel 2007
Conditional Formatting "knows" what a Subtotal is:
http://www.mediafire.com/file/tmfoiomemtz/03_03_09.xlsx

 

[jillybean via OfficeKB.com]

Thank you so much!

Excel 2007
Conditional Formatting "knows" what a Subtotal is:
http://www.mediafire.com/file/tmfoiomemtz/03_03_09.xlsx