Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table page filter not accepting multiple values. Workaround? | Excel Worksheet Functions | |||
how do I create a pivot table based on multiple sheets | Excel Discussion (Misc queries) | |||
Multiple MS Access table sources for pivot table | Excel Discussion (Misc queries) | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) |