After you add the fields to the pivot table's data area, drag the Data
field button to the right, onto the cell that contains the word 'Total'.

There's a picture he
http://www.contextures.com/xlPivot02.html


aspgk wrote:
1. Is there a way to create a pivot table where the sums are in the columns
and the groupings are in the rows...?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html