To add fields to the report filter, you drag them from the top of the PivotTable Field List
box to the Report Filter drop zone at the bottom of the PivotTable Field List box.
You can drag multiple fields to the Report Filter section. However, you cannot drag a field
that has already been used elsewhere in the pivot table.
For each field you add to the Report Filter section, you have a new drop-down in the
PivotChart Filter Pane box. When you initially open this drop-down, you can select only
one value from the drop-down. For example, you can select to filter the report to the east
region, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.