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
|