Creating rolling 12 value depending on month

[#1]

Hi

I have a graph with monthly values (last 24 month - working fine) and rolling 12 values (picture 1) and its OK when no selection of month. But when I select a month the rolling values only shows on the selected month (picture 2). I would like to present the rolling 12 to the selected month and then 12 month back.

and if possible show the data for a 24 month period as the monthly value

Today I use the following syntax with :

sum( aggr( rangesum( above( sum( {$<[YearMonth]>}  Revenue),0,12) ),[YearMonth]))

[kaushiknsolanki]

Check this link.

How to do rolling 12 months sum

Regards,

Kaushik Solanki