Easley06Helper II3 years agorunning 12 weeks Hi, is there a way to compute this Total Corporate = 48 Formula : Total Corporate / Average( first 3 weeks in the running 12(weeks) ) thanks. Show More
johnt75Super User3 years agoHave a look at the WINDOW function, you should be able to do an AVERAGEX over that.
Related contentRunning totals per weekRunning MaximumRunning sumRunning TotalsRunning Total per week/month
