Ask Question
28 October, 00:41

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?

+4
Answers (1)
  1. 28 October, 04:05
    0
    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
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “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 ...” in 📙 Business if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers