Pivot table

[JIM.H.]

This is my table
name price1 price2
d 11 5
d 11 5
e 13 4

This is Pivot Table I get
name Data Total
d Sum of price1 22
Sum of price2 10
e Sum of price1 13
Sum of price2 4
Total Sum of price1 35
Total Sum of price2 14

What should I do to represent it this way
name Sum of price1 Sum of price2
d 22 10
e 13 4
Total Sum 35 14

Thanks
Jim.

 

[Debra Dalgleish]

Drag the Data button onto the cell that contains the word 'Total'

There's a picture here:

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