I have two columns in pivot table one is cust_id and another one is Count of Invoice_id. Now i want to filter the count of Invoice_Id for value greater than or equal to 50. I am trying the vba code to that it is not working, can any one help me.
My code written is
Add2 Type:=xlValueIsGreaterThanOrEqualTo, DataField:=ActiveSheet. _
PivotTables(“PivotTable2”).PivotFields(“Count of Invoice_ID”), Value1:=50
It is always giving me the values of less than 50.