Hey Guys,
So I'm using RangeSum and above functions to calculate the sum of data for current year till current month. But i also have to show the data for last year upto current month in a Kpi. I'm using below expression but not sure how to calculate data of last year till current month. The expression is giving data upto whole year.
Exp:
Rangesum(above(sum({<conditions>}if((Year='Preyearvariable'),data)),0,Rowno()))
Any suggestion?
