Comments by navid fayaz (Top 1 by date)

This is my code that i can filter only one specific item like "AAA".help me to filter 2 or more specific items, "AAA" and "BBB".

ActiveSheet.PivotTables("PivotTable2").PivotFields("test1").PivotFilters.Add _
Type:=xlCaptionEquals, Value1:="AAA"