Rolling 12 months based on user date selection

[Anonymous]

Hi all,

I am trying to create a linechart. Based on the date that the user chooses, I need to display the current rolling 12 months and previous rolling 12 months. This also means I need a dynamic x-axis.

Right now I only have

Rangeavg(Above(sum(Sales), 0, 12))

Which should be the current rolling 12 months for the sum of sales.

Any ideas?

[Anonymous]

PFA, there just isn't any sales data in there though

[OmarBenSalem]

can't help if there is no data

[Anonymous]

Ok I'm not able to put that in. Thanks anyways!