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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"jillybean" wrote:

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.