This can be done - but can you describe the layout of your data please.
Otherwise it's too confusing.

"reno" wrote:

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