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

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

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

You're welcome! Thanks for letting me know that it helped.

Tim C wrote:
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






--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html