Hello,
I want to show sales for selected month and previous month in two object objects.
I have month field in a list box.
I am writing the following set expression however not getting any data:
=sum({<Month={$(=Max(Month))}>}Sales) and
=sum({<Month={$(=Max(Month)-1)}>}Sales)
Month list box lists the months as Jan, Feb, Mar...etc.
Also,If i want to show selected month and its previous month in text object what would be the express.
I tried the following expression it seems not working
vCurrentMonth=date(date#(Max(Month),'YYY'),'YYY')
vPreviousMonth=date(date#(Max(Month)-1,'YYY'),'YYY')
Please suggest.
Thank you,