i got code if the filter value is in report filter.
ActiveSheet.PivotTables("PivotTable1").PivotFields("CUSTOMER NAME"). _
CurrentPage = "ACC"
its work because here I have only single selection. all four tables are filter by a single word.
but I tried it but it not work if the "CUSTOMER NAME" is in Row Label
when recording the macro I got
With ActiveSheet.PivotTables("PivotTable1").PivotFields("CUSTOMER NAME")
.PivotItems("ACC.").Visible = True
.PivotItems("XYZ.").Visible = False
its means first I have to false the critiria which is filter than apply my filter.
i think its not time saving. :(
so can you please help me out.