Dana added a report filter to a PivotTable, but the list of filter values is long and difficult to use. What can she do to reduce the filter values in the list?
A) Use a slicer instead of a report filter.
B) Enter search text in the Search box above the list of field item values.
C) Sort the PivotTable first.
D) Use the Approximate Filter feature.

Question

Quizplus · Accepted Answer

Entering search text in the Search box will allow Dana to easily filter and find the specific values she is looking for without having to scroll through a long list of filter values.

Dana Added a Report Filter to a PivotTable, but the List