Thank you, Debra. I've looked everywhere for that, but it's one of those
things that you don't know what terms to use in your search. Of course I
should have realized that your website is the first place to look for pivot
table answers.
Thanks,
Tim C
"Debra Dalgleish" wrote in message
...
Drag the Data field button onto the cell that contains the word Total, as
shown he
http://www.contextures.com/xlPivot02.html
Tim C wrote:
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
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html