Hi All
I have got this SET expression from Mr sunny :-
Money(RangeSum(
Above(RangeSum(Above(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), 0, RowNo()))),
-Sum({<GL_CODE = {50010}>}TOTAL Aggr(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), YearMonth)))
, $(vMoneyFormatK_GL))
My question is , it is possible to modify to change the above expression to make it more dynamic. So when user not select any date it will display current month and year amount.
If user click on year=2015 , month = march. The above above amount will change to Last year same period amount.
Paul
