To arrange the fields horizontally, drag the Data field button onto the
cell that contains the word 'Total'.

There's a picture he

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


Looking for Help wrote:
I need help with pivot tables. I have created a pivot table with an open
order summary. I want to subtotal the units of each order and $ amount of
each order. These currently appear singularly by line item. Thanks!


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