Hello,

I have a pivot table named "DataFilterPivot" that has two filters "Open / Close" & "LOT CAT" and contain only one row label titled "Policy Number". I then have 2 data validation cells O5 & O6 (all in the same sheet) that contain options for those filters specifically:
Open / Closed: All, Open, Closed
LOT CAT: All, 1 - 30, 31 - 60, 61 - 90, 91 - 120, 121 +
If "All" is chosen for either drop down, I'd like the pivot tables to clear filters for the respective filter. I'd looked all over and have yet found VBA code that works with my scenarios.

Can anyone help?