Pivot Item. How to select only one.

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

Please Login or Register  to view this content.

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

Hi RomperStomper,

It's in the Filter area.

Thanks it works.

Do you know if there is some sort of loop I could use to set pivotsitem visible or not visible.


.pivotsitem(LoopVariable).visible = true

Thanks again for your previous answer.
very helpful.
Philippe

Thanks.

How would a simple example look like?

What I tried:

Please Login or Register  to view this content.

Thank you so much.