Pivot Table - deselecting multiple items quickly

[Guest]

Good day everyone.

Is there a way to deselect multiple items from a field that was dragged into the Pivot Table? I have some fields that have 100 choices and I would like to quickly display just areas that I need. This means that I may select 10 items and deselect 90. Then, get the numbers I was looking for and repeat the process for a different 10. Grouping isn't an option because people come with different requests, many with overlapping records.

Any ideas?

Thank you and have a great day.

 

[Debra Dalgleish]

You can use a macro to hide or show the items -- there's some sample
code on my web site:

http://www.contextures.com/xlPivot03.html