I have 4 columns as: Week Key Product Value I want to roll up 52 weeks and replace the value for the last week(for combination of key and its product and its corresponding value) with average of 52 weeks for same combination, and keep doing so till the last week by 52 weeks average., Example: Week Key Product Value 1 541 A 1.6 1 542 B 6.4 2 541 A 8.4 ............................... 98 541 A 3.4 98 542 B 4.5 So i want to roll up week 1-52 into week 1 and make 541-A combination values as average of that period and so for 542-B combination and move on for week 2-53, 3-54 and keep doing that for both the combinations.
... View more