Home > IT Answers > Microsoft Windows > Modify a pivot table
computerbug
5 pts.
 Modify a pivot table
Microsoft Office
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 pivot table to display the agent names as subcategories within the house types in the first column?

Software/Hardware used:
office 2010
ASKED: September 16, 2012  1:09 AM
UPDATED: September 17, 2012  12:08 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

…in the row labels area
 
In the “row labels area” of what?
 
You’re asking about a “pivot table” and tagged with “office 2010″, so I would guess this is Access. But can you give a little more explanation?
 
What is your table (tables?) structure? Is the “real estate agent field” the same as “agent names”? What exactly are you ‘pivoting’?
 
Tom

TomLiotta
 110,215 pts.