Pivot table

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.

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

There's a picture he

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

JIM.H. wrote:
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

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html