Excel Pivot Table
Posted by RickJ on December 13, 2001 1:54 PM
I work with very large spreadsheets (70,000 lines, 30 columns). I then set up pivot tables.
I know that I can put the field in the page area, and select one item at a time.
I want to place the field in the row area, "automatically de-select all items" and then re-select only those that I want within a pivot table?
Currently, I have to "de-select" each individually, which can often be 100 items to deselect if I want to show 10 of them at the same time.
I appreciate any help you can provide.