Solved

How Can One Filter a PivotTable Using a Report Filter

Question 5

Multiple Choice

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.

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions