Set Analysis - PrevMonth with unselected fields

[#1]

I have to fields for selecting months: Month (1,2,...), MonthName (Jan,Feb,..). Now I wan to select Previous Month in the chart

sum({$<Month={$(=Only(Month)-1)}>}Amount)

But my selections are in MonthName field not in Month. How can I refer to Previous Month if I have to select month in MonthName not in Month field? I mean when I select February, I want to show January too?

[Oleg_Troyansky · Accepted solution]

Add another Set Modifier to ignore user selection in MonthName, and everything will work:

sum({$<Month={$(=Only(Month)-1)} , MonthName= >}Amount)

[llauses243]

Hi Pedro,

This is my offer (see .zip)

Good Luck

/Luis.