set analysis for previous month - non-drillable?

[#1]

Hi guys,

I've implemented a simple previous month expression and thought it was working perfectly....That is until I made another selection.

1st expression: Sum(Case)

2nd expression Sum({$1<Master_Calendar_MonthYear = {"$(=date(AddMonths(Master_Calendar_MonthYear,-1), 'MMM-YYYY'))"}>}Case)

However, now when I select for example a geographical location, the 2nd expression remains static and therefore brings back all of last months cases and not just the selected city.
Any thoughts?

thanks,

[#2]

Hello,

simply remove the 1 in your set expression.

{$< ....>} or just {<...>}

The 1 means to query on the full data set, ignoring all your selections.

$ (or nothing) keeps existing selections, just overrides the part which is defined in the set.

hth,
Thilo

[#3]

Hi,

thanks for your reply. I did try this but it returns zero unfortunately!

[#4]

Basically it doesn't recognise the expression at all without the "1" in there and brings back a zero result. I'm assuming there must be a way in which the previous month expression can be made drillable and not just looking at the full set?