I have been given an assignment: to figure out how to come up with an average of records per week per order per item.

I am supposed to come up with the average number of records per item per order and also within week. (So Order 54416 would have an average of 3311 records) Problem is an order can have items that do not fall within the same week. This is a multi-level averaging assignment and for the life of me I can't figure out how to go about it!!! Any help or ideas are certainly appreciated!!! Thanks...Chris

Example:

Week Order Item Records

201001 54416 15103 3311

201001 54416 15104 3310

201002 54416 15105 3312

201001 54417 15106 3101

201001 54417 15107 3102

201002 54417 15108 3103