R
randy aitken
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 $.
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 $.