Never mind... answer was simple...brain temporarily stopped working!!!
Thanks!
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