| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table total question ?
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... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table total question ?
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 MajorSubtotalsNone -- Regards Roger Govier "paul" wrote in message ... 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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table 'Grand Total' question, average instead of sum | Excel Discussion (Misc queries) | |||
| Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
| Pivot Table Sub-Total question - basic | New Users to Excel | |||
| Pivot table question: How to display total and percent for data simultaneouly | Excel Discussion (Misc queries) | |||
| Pivot Table Calculated Field (Grand total question) | Excel Discussion (Misc queries) | |||
Hybrid Mode
