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
