ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Average of Pivot Subtotal (https://www.excelbanter.com/excel-discussion-misc-queries/197053-average-pivot-subtotal.html)

randy aitken

Average of Pivot Subtotal
 
I have a pivot table with the following row data in this order:

Customer - Order# - Part#

My data field is Sum of Total, ie the sum of the total $ paid for the parts by order by customer.

The pivot table provides me with a total by order, ie total $ paid for parts by order, and sum of customer, ie total $ paid for all parts for all orders.

If I change the sum of customer to average of customer it provides me with average $ per part but I want average $ per order.

I cannot find a way to average the subtotal by customer, ie what is the average order $.


All times are GMT +1. The time now is 03:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com