Microsoft
70-779 · Question #57
You have the PivotTable shown in the following exhibit. You need to display only rows in the PivotTable in which the sum of LineTotal is greater than 100. What should you do?
The correct answer is C. From Row Label, configure a Value Filter. See the full explanation below for the reasoning.
Question
You have the PivotTable shown in the following exhibit. You need to display only rows in the PivotTable in which the sum of LineTotal is greater than 100. What should you do?
Options
- AFrom Row Label, configure a Label filter.
- BAdd a slicer for LineTotal and select the values from the slicer.
- CFrom Row Label, configure a Value Filter.
- DAdd LineTotal to the Filters area of PivotTable Fields. Configure the Filters value.
How the community answered
(44 responses)- A7% (3)
- B5% (2)
- C77% (34)
- D11% (5)
Community Discussion
No community discussion yet for this question.