I want to omit (uncheck) values which starts with '16' in pivot filter. My values are 4 digits & are numbers only.
I tried this code but not working.
Dim PvtTbl3 As PivotTable
Set PvtTbl3 = Worksheets("FINAL").PivotTables("PivotTable3")
PvtTbl3.ClearAllFilters
PvtTbl3.PivotFields("OPUS CC").PivotFilters.Add Type:=xlCaptionContains, Value1:="<>16"
I tried this code but not working.
Dim PvtTbl3 As PivotTable
Set PvtTbl3 = Worksheets("FINAL").PivotTables("PivotTable3")
PvtTbl3.ClearAllFilters
PvtTbl3.PivotFields("OPUS CC").PivotFilters.Add Type:=xlCaptionContains, Value1:="<>16"