Select Multiple Pivot Field Items in VBA

[JungleJme]

Hi, i'm a novice with VBA but am trying to get it to cycle through my pivot tables and select three items on a particular filter.

The filter is "Role" and the pivots contain info regarding multiple roles - i want a macro to change all the pivots to show only 3 specific roles. The below code works, but the filters on the pivots only have one role selected ("PSSR")

Any ideas how i can adjust my code to select all 3 items and nothing else? Thanks

Please Login or Register  to view this content.

[Foosean010]

Depending on the name of your pivot table, this code should work for what you're looking for.

Please Login or Register  to view this content.