Orientation of multiple data items in Pivot table

[Tim C]

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]

Drag the Data field button onto the cell that contains the word Total,
as shown here:

http://www.contextures.com/xlPivot02.html

 

[Tim C]

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]

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