Selecting multiple filters in a pivot table

G

Guest

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.
 
D

Debra Dalgleish

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.
 

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

Top