Allow multiple selection in the filter area

You can specify whether the field in the filter area will allow single or multiple selection. In single-selection mode, selecting an item automatically clears the previous selection. In multiple-selection mode, when you select an item, previously selected items remain selected.

1. In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
2. Select the field in the filter area for which you want to change the setting.
3. On the toolbar, click Commands and Options , and then click the Filter and Group tab.
4. Select or clear the Allow selecting multiple items when in filter area check box.

Notes

• By default, multiple selection is enabled.
• This setting applies only when the field is in the filter area. If you move the field to a row, column, or detail area, the field will always support multiple selection.