Sub CreatePivot() Dim PItem as PivotItem Dim PTable as PivotTable
For Each PItem in PTable.PivotFields("Employee_Name").PivotItems
If PItem.Name Like "*XXX*" Or PItem.Name Like "*YYY*" Or PItem.Name Like "*ZZZ*"
PItem.Visible = True
Else
PItem.Visible = False
End If
Next PItem
End Sub