Second Set Expression to add second filter

[Qlik007]

I have one big tables with order related fields 

in KPI i need to show sales by region 

I am showing sum of product sold by region

Master item  = sum({<region_name= { ‘Americas’}>} Dollar_value)

I  displaying this in graph where X axis is ( YEAR &'-'& Month) 

Y axis - Above master item , with 2 other master item 

now I need to add set expression where it shows all the months data except current month

i dont have full date but i do have columns(attributes) which gives me month and year separate

my month filed name is “Month” and year field is called “Year “

this is what i have tried but obviously it doesn’t work

sum({<

Month={MonthEnd('$(today()),-1')},

region_name= { ‘Americas’}

>} Dollar_value)

[BPiotrowski]

Hi, @Qlik007 

Try this one for prev month, you can also add {1} if you want to ignore user selection.

sum({<Date={"<=$(=MonthEnd(AddMonths(today(),-1))"},region_name= { 'Americas'}>} Dollar_value)