How to enable filtering in set analysis

[JLL72]

Hi 

I have this set analysis below to work out sum of sales for the past 12 months ( my MonthYear Numberic column is like 202009, 202008 )

=NUM(SUM(

{1<[MonthYear Numeric] = {"<=$(=Max([MonthYear Numeric])) >$(=Max([MonthYear Numeric])-100)"},
>}Sales),'€#,##0')

But this set anlysis is fixed at the moment, when I try to apply filters, this expression wouldn't be affected. 

I need to filter this by [Client] and [Product]...

Could someone please help me?

Thanks

Joe

[Anil_Babu_Samineni · Accepted solution]

Try this

=NUM(SUM({<[MonthYear Numeric] = {">=$(=AddMonths(Max([MonthYear Numeric]),-12))<=$(=Max([MonthYear Numeric]))"}>}Sales),'€#,##0')

[JLL72]

Thank you ! worked perfectly !