Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
I want to create a KPI to show last month sales.
I have created a date field to show this
SUM({<DATESORT={-1}>}Sales)
However If i select DATEMONTH, I want the above expression to be dynamic and change to the selected month.
Any ideas?
THanks,
Aaron
Then why are you hard coding this? May be try this
Sum({<DATESORT = {$("$(=Max(DATESORT)-1)"}>}Sales)
Or this
Sum({<DATESORT = {$("$(=Max(DATESORT)-1)"}, DATEMONTH>}Sales)