As He Prepares His Assignment for His Marketing Class, Ted

Multiple Choice

As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job.
-Ted wants to be able to analyze date data in his PivotTable by month.What must he do with the date field in his PivotTable?

A) He must aggregate the data by the date field.
B) He must cluster the data by the date field.
C) He must sort the data by the date field.
D) He must group the data by the date field.