View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Karen Karen is offline
external usenet poster
 
Posts: 447
Default 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