Set analysis expression for current/previous month not working

[Anonymous]

I have this expression, but it doesn't show the max YearMonth Sales if nothing is selected, it shows all sales for the year

sum({$<YearMonth={$(=Max(YearMonth))}, 

Year, 

Quarter, 

YearMonth>}Sales)

Likewise the expression for the Previous YearMonth doesn't work either. It shows the same data as the Max YearMonth

sum({$<YearMonth={$(=Max(YearMonth)-1)}, 

Year, 

Quarter, 

YearMonth>}Sales)

Please Help!

Thank you!!

[kaushiknsolanki · Accepted solution]

Hi,

   Have a look at the Application attched.

Regards,

Kaushik Solanki

[Anonymous]

Awesome, works great.

Thank you so much for your help