What if this were a pivot table and there were one more row of data.

For instance, I have customer, order#, and item# in my row fields, and sum of total in my data field.

I have subtotaled on order# such that I have a total for each order.

Now I wish to find the average total per order by customer.

When I set the average on the customer field it gives me average of total, ie, the average price per item. But I am seeking instead to average my subtotal.

(Excel 03)