Calculation depending on last 12 months ?

[suvechha_b]

Hi All,

How can I calculate the expression for last 12 months from max (CLAIMS_CAPTURED_MONTH_NAME).

Value for field is CLAIMS_CAPTURED_MONTH_NAME=201908

Count({$<[Partner Grouping Name]={'Personal & Commercial'},[Section Latest]={'Motor'},CLAIMS_CAPTURED_MONTH_NAME={"$(=(Max(CLAIMS_CAPTURED_MONTH_NAME)))"}>}
Distinct [Claims Captured Claim Number])

Sample model attached.

[AdiPai]

Your expression should look something like this  

=SUM({<OrderDate = {">=$(=YearStart(Today(),-1,3))<=$(=MonthEnd(Today()))"}>}Sales)