How to hide some of the PivotItems in a Pivottable?

[feipezi]

Hi,

I have a Pivottable with some PageFields and Column/RowFields. As I select a value from PageFields, I am expecting to see only the ColumnFields under the PageField value selected, not everybody. But everybody is shown.

First I tried Label Filter, but under 'Begin With' there is only one value allowed, like Add Value1="AAA" things like that. It means, you cannot do it like 'Value1=:"AAA", Value2=:"BBB"...; then I used a loop to check the values and hide the values that are not "AAA", "BBB". But it will take forever if I have a whole bunch of values. So the method is not working.

I don't have the code handy. But I'll show you guys as I back to work.

Thanks in advance.

 

[SkipVought]

Hi,

Use MS Query to determine a list based on a criteria equal to you PT selection.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}