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
I tried to do something likeHTML Code:
Unfortunately it did not work,
for each pivotitem in Pivot if pivotitem ="USD" Then .pivotitems("USD").visible = true next pivotitem
any suggestions would be very helpful.
Thanks in advance for your time.
Philippe
Which area of the pivot table is that field - row, column, or filter?
Everyone who confuses correlation and causation ends up dead.
Hi RomperStomper,
It's in the Filter area.
In that case you want to set the Currentpage property of the field to "USD".
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
Yes, you can just loop through the PivotItems collection of the PivotField.
Thanks.
How would a simple example look like?
What I tried:
Dim ItemPT as pivotfield for each ItempPT in PT if itemPT.name = "USD" then msgbox "it works" Next Itempt
for exampleDim ItemPT as pivotItem for each ItempPT in PT.PivotFields("some field").PivotItems if itemPT.name = "USD" then msgbox "it works" Next Itempt
Thank you so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks