Jamie wants to be able to analyze date data in her PivotTable by month.What must she do with the date field in her PivotTable?
A) She must aggregate the data by the date field.
B) She must cluster the data by the date field.
C) She must sort the data by the date field.
D) She must group the data by the date field.

Question

Quizplus · Accepted Answer

Jamie must group the data by the date field in order to analyze it by month. This will allow her to view the data categorized by months rather than by individual dates.

Jamie Wants to Be Able to Analyze Date Data in Her