moving average & rank
have listing of stores and weekly sales, want to calculate the last four
weeks moving average, e.g, this week (wk4) would be weeks 1-4, next week
(wk5) would be weeks 2-5 and so forth.
second caluculation would be to rank the stores by weekly sales on same four
week moving average.
thx
|