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.