Hi everyone,

I create a pivot table and want to apply a filter for only one item.

For instance, if my data set has currencies. I would only want to see USD

HTML Code: 
I tried to do something like 

for each pivotitem in Pivot

if pivotitem ="USD" Then .pivotitems("USD").visible = true 

next pivotitem
Unfortunately it did not work,
any suggestions would be very helpful.
Thanks in advance for your time.
Philippe