RE: East Reports Question
I am not sure how to accomplish with saved search or canned reports.
Always you could dump a saved search to excel for a one time report and use pivot tables.
I would look into analytics and the pivot table function. I would start at a sales order data set with customer and line items in the data set.
Then make a picot table with customer as the rows. You can have one for revenue and one for item quantity for easier sorting.