Ask Question
3 June, 23:07

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?

+2
Answers (1)
  1. 3 June, 23:09
    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?
Find 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 the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers