Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Orientation of multiple data items in Pivot table
Excel 2003 on Windows XP Pro SP2
Sheet1 has columns for ClientName, TransAmount, AgencyComm and ProdComm. I am trying to use a pivot table to aggregate the data by ClientName. I can get a table that gives me all of the information, but isn't laid out logically. I get 3 rows for each ClientName, with Sum of TransAmount, Sum of AgencyComm and Sum of ProdComm on separate rows. For example, current results: ClientName Data Total Alpha Sum of TransAmount 100 Sum of AgencyComm 20 Sum of ProdComm 10 Beta Sum of TransAmount 50 Sum of AgencyComm 5 Sum of ProdComm 2 etc. I would like to get each sum in a separate column. Desired results: ClientName Sum of TransAmount Sum of AgencyComm Sum of ProdComm Alpha 100 20 10 Beta 50 5 2 Gamma 200 50 25 Delta 150 75 30 Is this possible with a pivot table? Thanks, Tim C |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table Data area show/hide behavior | Excel Discussion (Misc queries) | |||
drag multiple data items into pivot | Excel Worksheet Functions | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions |