Hello there!
Imagine you have a Pivot Table with at least one page field at the upper left corner. Is it possible to select more than one value for that field? I tried to solve it with a VBA code like:
ActiveSheet.PivotTables("PivotTable1").PivotFields("Colors").CurrentPage = "Green" or "Red" or "Blue"
Is there any solution?
Best Regards
Pedro
Imagine you have a Pivot Table with at least one page field at the upper left corner. Is it possible to select more than one value for that field? I tried to solve it with a VBA code like:
ActiveSheet.PivotTables("PivotTable1").PivotFields("Colors").CurrentPage = "Green" or "Red" or "Blue"
Is there any solution?
Best Regards
Pedro