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.

Pivot Table Hide Zero Subtotals - Excel 2007
 

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.

Pivot Table Hide Zero Subtotals - Excel 2007
 

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

Pivot Table Hide Zero Subtotals - Excel 2007
 

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

Pivot Table Hide Zero Subtotals - Excel 2007
 

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