Pivot Table Question

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

Guest

Hello,

I have created a pivot table in Excel 2002 that is using a list of data from
another tab in Excel 2002. Within the page filters, I have several filters
in which I would like to be able to select multiple items at one time but
can't figure out how to do it. For example, one of my page filters is
'Category'. Currently, I can only select ONE of the following: 'All',
'Category 1', 'Category 2', 'Category 3', etc. I would like to be able to
select multiple items at once such as 'Category 1' and 'Category 2' at the
same time. Any help would be greatly appreciated.
 
You can temporarily move the page field to the row area, and select the
items you want to show.
Then, move the field back to the page area.

Or, double-click on the page field button.
In the Hide Items list, select the items you want hidden, then click OK
 

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

How to ignore a column of numbers in Grand Total for rows 1
Pivot tables, IF statements, vlookups? 2
Validation list with formula? 3
VBA: How can I use a string variable as autofilter criteria? 4
How to limit validation list 3
Subtotal percents in pivot table 1
Pivot Table-two tables same data, can I used the same page control 1
Dynamically sized table compiled from unsorted rows with blank entries 2

Back
Top