Rolling sum in KPI vs Previous value

[Ramu_i]

Hi All,

I have Year, Quarter, Month filters are there,

In KPI I want to get rolling sum of months, and Quarter selected year wise,

Means --- If I select the Feb Month , it will display the Jan and feb month data, If Dec--- It will display the Jan to dec data.

find the variance also like  current-previous/previous

let assume current month is December , database having November data, 

In variance display the for Q4 is     ((2021 -Jan to 2021 - Nov ) -(2020 -Jan to 2020 - Nov ))/(2020 -Jan to 2020 - Nov )

Thanks advance 

Ram