Question: How can one filter a PivotTable using a report filter? a. Right-click a cell in the pivot table, and click Pivot Table Options, then set

How can one filter a PivotTable using a report filter?
a. 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.
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. Click on the drop down arrow for a Report Filter in the pivot table and Click (All).
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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!