MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.

Posted by Mark W. on December 13, 2001 2:00 PM

This can be handled in a number of ways. Two of
which are...

1. You could add your 31st column to your data and
populate it with a formula that returns a boolean
result answer the question, "Is this field's item
of interest?"

2. You could create a 2 item Group based on the
field in question, move the new field to the
PAGE area, and choose the desired grouping item.

Posted by Mark W. on December 13, 2001 2:01 PM

BTW, I doubt that your data list has 70,000 rows! : ) (nt)

Posted by RickJ on December 14, 2001 6:05 AM

Correction/Number of rows

I will try your suggestions. You are right about the number of rows. It is actually about 50,000 rows now, and will approach 60,000 by the end of the year.