I was confused by the moving average example given in instructions...the three numbers given divide by 3 does not equal the moving average supplied as the example answer.
Month: Value: Running 3 mo. Average:
1 218 218
2 200 212
3 272 233
218+200+272 = 690 / 3 = 230 (not 233)
I am fairly pleased with my answer from an eloquence perspective. Would love for someone to give it a look over, but seems to be producing the correct output.
Originally was doing multiple multi-row formulas, but the transpose then cross tab approach worked pretty well.