Pivot Table - deselecting multiple items quickly

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deselect items in Pivot Table 3
filtering dates in a Pivot Table Report Filter 3
Deselect All in a Pivot Table 1
Pivot Table hiding row removes from row ! 1
Can't deselect drop down field in a pivot table 1
Pivot Table Grouping 2
deselect cells within a range of cells 3
Deselect (Unselect) Cells 22

Back
Top