Try with filter
If not we need to go with vba
ActiveSheet.PivotTables("PivotTable4").PivotFields("Traders Name")
.PivotItems("GTL_USA").Visible = False
.PivotItems("XYZ").Visible = False
cheers
Try with filter
If not we need to go with vba
ActiveSheet.PivotTables("PivotTable4").PivotFields("Traders Name")
.PivotItems("GTL_USA").Visible = False
.PivotItems("XYZ").Visible = False
cheers