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?
A.
Add a slicer for LineTotal and select the values from the slicer
B.
Add LineTotal to the Filters area of PivotTable Fields. Configure the Filters value
D, I tested it, You can choose a label of VALUE filter. A is INcorrect because a slicer value, will show the unique values and not greater than 100 option.
This section is not available anymore. Please use the main Exam Page.70-779 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
imran
Highly Voted 5 years, 10 months agoAurelkb
Highly Voted 5 years, 9 months agoTzozo
Most Recent 4 years, 11 months agoWaltmas
5 years agopanal
5 years agoPowerLjubica
5 years, 1 month agoAiti
5 years, 2 months agoAiti
5 years, 2 months agoOlivia
5 years, 5 months agoAddabea
5 years, 5 months agoJeroenMicrosoftExamen
5 years, 6 months agoSN22
5 years, 6 months agoAnnelize
5 years, 8 months agomohroshdy
5 years, 8 months agoimran
5 years, 10 months ago