Lindsay wants to filter a PivotTable to display only June revenue data.Which of the following fields should she add to the Filters area?
A) Revenue
B) Month
C) Summary
D) Filter

Question

Quizplus · Accepted Answer

The field "Month" is the best choice as it allows for filtering of specific months, in this case June. "Revenue" would not allow for filtering by specific months and "Summary" and "Filter" are not relevant fields for filtering.

Lindsay Wants to Filter a PivotTable to Display Only June