ExcelBanter - Ignore 0 in pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Ignore 0 in pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/20490-ignore-0-pivot-table.html)

Johan

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?

All times are GMT +1. The time now is 01:33 AM.