Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide zero values in a pivot table
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. -- Dmitri |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide zero values in a pivot table
One way (Excel 2003)...
Select Tools Options. On the View tab, uncheck Zero values. Click OK. Hope this helps, Hutch "Dmitri" wrote: 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. -- Dmitri |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide zero values in a pivot table
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. -- Dmitri "Tom Hutchins" wrote: One way (Excel 2003)... Select Tools Options. On the View tab, uncheck Zero values. Click OK. Hope this helps, Hutch "Dmitri" wrote: 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. -- Dmitri |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide zero values in a pivot table
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 On Mar 27, 1:58*pm, Dmitri wrote: 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. -- Dmitri "Tom Hutchins" wrote: One way (Excel 2003)... Select Tools Options. On the View tab, uncheck Zero values. Click OK. Hope this helps, Hutch "Dmitri" wrote: 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. -- Dmitri- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hide zeros on pivot table | Excel Worksheet Functions | |||
how can i hide zero results row in a pivot table? | Excel Discussion (Misc queries) | |||
How do I hide rows in a pivot table with zero values? | Excel Worksheet Functions | |||
how to hide 0 values in pivot table | Excel Discussion (Misc queries) | |||
How do i hide rows in pivot table that has zero values? | Excel Discussion (Misc queries) |