Archive of Mr Excel Message Board

Back to Pivot Tables in Excel archive index
Back to archive home

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.

Re: Excel Pivot Table

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.

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

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

Correction/Number of rows

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

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.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.