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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
