Pivot table total question ?

P

paul

I want to build a pivot table that will give me totals...like this...

A B
MAJOR ZIP
Accounting 10002
Accounting 10003
Accounting 10003
Accounting 10005
Biology 10005
Biology 10005
Biology 10007

So I want to build a total that will look something like this...will
tell me how many accounting people are in zip 10003 etc.

MAJOR ZIP TOTAL
Accounting 10003 2
10002 1
10005 1
Biology 10005 2
10007 1

How would I build this total? I did a =COUNT(B1) but this did not
work...
 
R

Roger Govier

Hi Paul

Drag Major to Row area
Drag Zip to row area
Drag Major again to the Data area

If you don't want the Subtotal to appear after each major, double click
Major>Subtotals>None
 

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 (totals) question ?? 1
Excel Convert Multiple Rows into Multiple Columns 6
Excel Convert Multiple Rows into Multiple Columns 1
Normalization Question 6
How to group my student data using Excel 2
Split a Table 2
Row Numbering 5
Return cell contents based on conditional lookup 15

Top