Hi Everyone, Happy New Year to you and Yours.
When filtering a Pivot Table, I know you can use the field drop-downs to select various items to filter. If it's a Page field, you can choose All or any one of the items in the list.
If it's a Row field you can Uncheck the items you don't want.
What about if the drop down has hundreds of items, but you only want 2 or 3 of them?
Manually Unchecking all but 2 out of 300 items in a Row Field is out of the question, really!
It's not possible to have more than 1 Page field with the same name, which would allow you to select, say "John" or Janet"
So can it be done? If so, how?
P.S. I bet a trillion Space Credits that;
A. I've overlooked something REALLY simple or
B. There's a FAQ or past query on this very subject :wink2: