Hi All,
My Curr year sales exp:
=Sum({<CurrencyFlag = {'DateWiseCurrency'} ,KPIsFlag={'SalesCost'},ACT_BKG_FLAG={'BKG'}>}BookingSales/Currency_Rate)/vValue
Last year Sales Exp:
=Sum({<CurrencyFlag = {'DateWiseCurrency'} ,KPIsFlag={'SalesCost'},ACT_BKG_FLAG={'BKG'},CommonYear={'$(vPSY)'}, Day={">=Max(Day)<=(day(Today()))"}>}
BookingSales/Currency_Rate)/vValue
Variable: vPSY=max(Year)-1
I want last year till date sales for all months compare with this year till date sales all months, The completed months never change the sales values, please find the attachment.