Hide zero values in a pivot table

  • Thread starter Thread starter Dmitri
  • Start date Start date
D

Dmitri

At our office we have people using both Excel 2007 and Excel 2003. Is there a
functionality in either (or both) of them to hide rows (or columns) that have
ZERO (not blank) values in an OLAP Pivot table without having to write
macros. It would simplify most of the reports, but so far I could not find a
clear answer for it. Thank you very much in advance.
 
One way (Excel 2003)...

Select Tools >> Options. On the View tab, uncheck Zero values. Click OK.

Hope this helps,

Hutch
 
Thanks for the reply. But that only seems to remove actual zeroes replacing
them with blanks. The row is still shown in the table. Thanks again.
 
In a column to the side of your table enter a SUM formula to add up
the columns with numbers in and copy this down. Then apply Autofilter
to this column, selecting Custom | Not Equal To | 0 (zero) and this
will hide the zero rows.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter pivot table zero values 1
Hiding Zero Values in a Pivot Table - MS Excel 2007 4
Surpressing rows and columns with zero values in a pivot table 1
Pivot Table - Hiding Zero Values 2
Question on the occupied field of the pivot table in excel spreadsheet 0
Hiding rows containing zeroes or blanks in pivot tables? 2
hiding zero values in a pivot 1
Excel 2007 Pivot Tables - do not display zero values 2

Back
Top