| 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... |
| 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) | |||
Threaded Mode
