How can one filter a PivotTable using a report filter?
A) Click on the drop down arrow for a Report Filter in the pivot table and Click (All).
B) Click the Report Filter's drop-down arrow,then click on an item to select an item in the list and click OK.
C) Right-click a cell in the pivot table,and click Pivot Table Options,then set the 'Display Fields in Report Filter Area' to 'Down,Then Over' On the Layout & Format tab.
D) Right-click a cell in the pivot table,and click Pivot Table Options,then set the 'Display Fields in Report Filter Area' to Over,Then Down' On the Layout & Format tab.

Question

Quizplus · Accepted Answer

To filter a PivotTable using a report filter, click on the drop down arrow for the Report Filter in the pivot table and then click on an item to select it in the list and click OK. This will filter the PivotTable based on the selected item in the report filter.

How Can One Filter a PivotTable Using a Report Filter