subtotals in a pivot table
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! |
subtotals in a pivot table
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 |
All times are GMT +1. The time now is 03:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com