Set analysis include date selection

[aaronnayan]

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

[sunny_talwar]

Then why are you hard coding this? May be try this

Sum({<DATESORT = {$("$(=Max(DATESORT)-1)"}>}Sales)

[sunny_talwar]

Or this

Sum({<DATESORT = {$("$(=Max(DATESORT)-1)"}, DATEMONTH>}Sales)