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.

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.

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.


Shane Devenshire wrote:
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.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200903/1

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

Thank you so much!


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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200903/1