Multiple Columns for Pivot Table

[Guest]

I have data with a name and two columns of amounts. I would like to make a
pivot table that gives me one row for each name with a column for each of the
two amounts. I can only seem to get it to include one of the columns.

 

[Debra Dalgleish]

Add both amount fields to the pivot table's data area
Then, drag the Data button onto the cell that contains the word Total.

There's a picture here:

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

 

[RichardSchollar]

Hi Marilyn

Place the name field in the Row area and then both of your amount
fields in the Data area of the pivot table (not the Column area) and
once the pivot table is created, right-click on the Data button and go
Order>Move to Column.

Hope this helps!

Richard