View Single Post
  #1   Report Post  
Johan
 
Posts: n/a
Default Ignore 0 in pivot table

I have a big list with data. A lot of data are accumulated formulas and
therefore the results are often shown as 0 (zero) Now i want to skip all data
with result 0 (zero) in pivottable. So only data with result 0 should be
shown in the pivottable.

Any ideas?