VBA to filter out "0" in my Pivot Chart

  • Hello,

    I am trying to write a VBA code to help me filter out all "0" values from two filters on my pivot chart. The data is extracted from an external source and I wish to always have the data filter out the zeroes on refresh. As of right now, on refresh the chart removes one of my filters and excludes new values from the other. I wish to make a macro where I can always remove 0 values from my pivot items. Here is my current code: (I am getting the error: "Unable to get PivotItems property of the PivotField class")

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!