Filtering an Excel Report

You can apply filters to an Excel PivotTable report to exclude information from the report. The filters that you add to a report are cumulative.

To allow multiple filters per field, you must select the Allow multiple filters per field check box on the Totals & Filters tab of the PivotTable Options dialog box. To do this, right-click anywhere in the PivotTable report layout area, and click PivotTable Options on the shortcut menu.

When you add filters before you build a report, it helps reduce the time that it takes for the report to update as you work with it.