subtotals in a pivot table

[Looking for Help]

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]

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

There's a picture here:

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