Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Hi,
Have a look at the Application attched.
Regards,
Kaushik Solanki
Awesome, works great.
Thank you so much for your help