Issue With previous month set analysis expression

[svsudhakar]

Hi ,

I have written one SET Expression to get the last month values. But this expression is working fine with out any selection, after made the selection of any month its not working properly(Showing '0').

Please suggest on this.

Below is the Set Analysis Expression

sum({<Financial_Year={$(=max(Financial_Year))},MonthName={"$(=MonthName(max(MonthName)-1))"}>} [Value] ))/1000000

Thanks in Advance,

regards,

SS