You have a PivotTable. You want columns for each year of sales, and you also want the months under each year in their own column. How can you accomplish this?
Understand the Problem
The question is asking how to configure a PivotTable to display sales data in columns for each year, while also having the months separated under each year. It requires understanding how to manipulate fields in a PivotTable application to achieve this layout.
Answer
Add the Order Date and Years fields to the Columns box, and make sure Years is above Order Date.
Add the Order Date and Years fields to the Columns box, and make sure Years is above Order Date.
Answer for screen readers
Add the Order Date and Years fields to the Columns box, and make sure Years is above Order Date.
More Information
Placing the 'Years' above 'Order Date' organizes the data hierarchically, allowing each year's sales to have its own columns and then be broken down by month.
Tips
Ensure 'Years' and 'Months' are selected when grouping dates, as missing this step might not show the desired breakdown.
AI-generated content may contain errors. Please verify critical information