| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table columns
I need a table which reflects the total number of cases each analyst has in a
column, and the total amount of fee each analyst has achieved in a column next to it. How can I do that? Case Number Fee Analyst CASE1 10 A CASE2 15 B CASE3 10 C CASE4 25 A CASE5 57 D CASE6 44 C CASE7 32 B CASE8 70 D CASE9 24 A CASE10 64 C CASE11 33 B CASE12 12 D CASE13 95 A Thanks, Karen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
| Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
| How do I get more columns in a pivot table? | Excel Discussion (Misc queries) | |||
| Pivot Table Columns | Excel Discussion (Misc queries) | |||
| Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
