Max year function issue

[kiansin]

Hi , 

I have a expression script as above : 

Sum ( {<SalesPeriodYearMth_DocDate={">=$(=Date(AddMonths(max({<Source={'Order Entered'}>} SalesPeriodYearMth_DocDate),-12), 'YYYYMM'))<=$(=Date(AddMonths(max({<Source={'Order Entered'}>} SalesPeriodYearMth_DocDate),0),'YYYYMM'))"}>} EURSales)

My expected output is EUR sales from year period "202111" until "202211"

(Current  year period is "202211" and I need the table rolling by 13months hence initial by "202211")

--------------------------------------------------------------------------------

Once I was selected "Yes" from dimension "cyclone"

the year period auto changed to "202110 "  until "202210" instead of "202111" until "202211"

it supposed to show the Invoiced from year period "202111" to "202211",

but it didn't , why ?

------------------------------------------------------------------------------------------------------------

As you can see as above :

It has data with "Cyclone" was equal to "Yes " in year period "202211" 

But when I selected "yes" from column cyclone , it automatically ignore the year period "202111" and end with "202110"

Why?

Could anyone help on this issue please ?

Thanks in advance !!