How do I use a pivot table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a pivot table, that I need to be pivoted to show the membership by
state across the top per account down the left side. How do I do that?
 
Just make the state field a column field and account a row field with the
membership by state field as the data field.
 
Add the State field to the Column area
Add the Account field to the Row area
In the data area, add a field that has an entry in every row of the
source data, e.g. MemberID or MemberName.
Summarize that field by Count, instead of Sum.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table filter list - listing irrelevant subcategorys 1
pivot table data 2
Different ways to build Pivot table 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Referencing a pivot tables Grand Totals Column 1
Pivot Table Help 1
Pivot table formulas 1
Pivot Table Options 'Fields per column' 1

Back
Top