How to create a graph with rolling 12m up until today and last year?

[robinwiman]

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?