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