View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dmitri Dmitri is offline
external usenet poster
 
Posts: 4
Default 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