Hi,
I have a graph that I want to change into Rolling 12 months of sales.
X-axis: weeks (1, 2, 3, 4 etc.)
Y-axis: sales
I want to show the R12 "last year" and the R12 up until today.
I plot the sales already using:
Sum({$<Year={$(=Max(Year))}>}Fsgexkl_EUR)
And
Sum({$<Year={$(=Max(Year)-1)}>}Fsgexkl_EUR)
These two will give me the sales per week for each year.
So what I want is the same thing, but Rolling 12 months.
How can I do this?