View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stevek
 
Posts: n/a
Default Pivot Table question


Is there a way to automatically hide data with results = 0 on a pivot
table? I have a long list of output, but the majority of data points
are = 0. I only want to show output with positivr results, thereby
limiting the size of the table.


--
Stevek
------------------------------------------------------------------------
Stevek's Profile: http://www.excelforum.com/member.php...o&userid=32134
View this thread: http://www.excelforum.com/showthread...hreadid=518884