Pivotable - Zero values

nc · Feb 23, 2004

Is there a method of hiding zero values automatically in
pivot tables?

Thanks.

BrianB · Feb 23, 2004

Double click the field header
Uncheck "Show items with no data

nc · Feb 24, 2004

Thanks for your response.

I have followed your instructions but the zero values
remain in the report.

Any other ideas.

Surpressing rows and columns with zero values in a pivot table	1	Jan 14, 2010
Excel 2007 Pivot Tables - do not display zero values	2	Mar 10, 2010
Hiding Zero Values in a Pivot Table - MS Excel 2007	4	Sep 3, 2008
Need the grand total pivot table filtered worksheet?	1	Jul 6, 2009
Filter pivot table zero values	1	Sep 17, 2009
Pivot Table Shows Only Zeros	3	Jan 20, 2010
Pivot Table - Hiding Zero Values	2	Aug 22, 2008
PIVOT Display is WRONG	3	Aug 13, 2009

Ask a Question