Currently, the House Types field is in the Row Labels area, the Real Estate Agent field is in the Column Labels area, and Sum of List Prices is in the Values area. How can you modify the PivotTable to display the agent names as subcategories within the house types in the first column?

Respuesta :

Answer:

Explanation:

Based on the information provided within the question it can be said that in order to achieve this task you would need to do a two things. Firstly, you need to drag the Real Estate Agent field from the Column Labels area. Once you have that you can drop it below the House Types field in the Row Labels area. This will allow you to display the agent names as subcategories within the house types