Modify a pivot table

5 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    ...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
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following