Suppress zeros in a pivot table

Hello, with the data in the attached sheet, I create several different pivot tables that need show the count of the information in the columns M:DU. My issue is that the data is sent to me from a third party and the columns contain zeros that cause the counts to inflate. What I would like to be able to do is run a macro that will search out any zeros in M:DU and replace them with a blank cell. Unfortunately the number of rows increases with every monthly reporting cycle so the macro would need to be able to accommodate for that.


Thanks for any help you can provide!
Clayton

Try this macro on your sheet:

Please Login or Register  to view this content.

Here's an alternate version that only evaluates each column, as a whole, once, so it could be noticably faster on larger data sets.

Please Login or Register  to view this content.