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
Mark,
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.
