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

Orientation of multiple data items in Pivot table
 

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

Orientation of multiple data items in Pivot table
 

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

Orientation of multiple data items in Pivot table
 

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