You have the following tables in a data model.
You create a PivotTable to display SaleAmount by Month. A sample of the results are shown in the following table.
You need to ensure that the data appears in chronological order.
What should you do?
A. In the data model, modify the Sort By Column setting for Date[Month Year]
B. From PivotTable Fields, add Date[Year] to the Rows area
C. In the data model, modify the Sort by Column setting for Sales[Date]
D. From PivotTable Fields, modify the Field Settings for Date[Month Year]
