I am trying to calculate an moving average cumulative, but I could not find the result that I am looking for. What I am trying to do is a moving average for the last 8 weeks cumulative until week 52 like in the below table.
I already have real information so I would like to calculate moving average of last 8 week starting from week 26 to week 52
First mean works well but the second one (cumulative doesn’t work because is mean of the previous mean) so just there is missing how to make a mean cumulative untill week 52
Yes I’ve already done and it worked but there is a thing missing. I have to calculate cumulative mean untill week 52 and now I only have information untill week 27 so what I have to do is how to set up future missing weeks. like in this example
Yellow fields are calculated cumulative using previous mean