Selecting multiple filters in a pivot table
 

When I use filters on pivot tables that others create, I can select multiple
values on which to filter. There is a little white box next to each item
that I can select by putting a check mark in it. However, when I create a
pivot table, I can only select one item from the filter at a time. How do
you set up the pivot table so you can select multiple items?

Thanks.
--
Anne

If a field is in the Page area, it doesn't have check boxes. Could that
be the problem?

To select multiple items from a page field, you can temporarily move the
field to the row area, select the items, then move the field back to the
page area.

Anne wrote:
When I use filters on pivot tables that others create, I can select multiple
values on which to filter. There is a little white box next to each item
that I can select by putting a check mark in it. However, when I create a
pivot table, I can only select one item from the filter at a time. How do
you set up the pivot table so you can select multiple items?

Thanks.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html