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?

Question image

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

Thank you for voting!
Use Quizgecko on...
Browser
Browser