Hi Steve:

It still wouldn't work. I may have a customer called ABC with 2 orders (e.g. $2000 and $2400) and 4 line items each. If I were to summarize by customer, I would get an average of $2200 and not the total dollar amount ($4400) for that customer.
If I were to summarize by order number, I would get the correct average numbers ($2000 & $2400), but then I would still have to manually add up both to get the total for that particular customer. Does this make sense?

Andre