Sum last 12 month from current month dimension value

[Facundo]

Hi,

I need to create a measure with the sum of MedicalExpenses from the last 12 months just for the unsubscribed Members in the current month.

How can I accomplish that requirement?

Columns: MedicalExpenses , Members , UnsubscribedMembers

Thanks,

Facundo

[dplr-rn]

need more details to help properly but you can use set analysis to achieve it.

something like below

Sum({<Type={'Unsubscribed'}, Date={">=$(=AddMonths(today(),-12))"}>}SalesAmount)

refer below for more on set analysis

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

[Channa]

Sum({<Type={'Unsubscribed'}, Date={">=$(=Monthstart(AddMonths(today(),-12)))"}>}SalesAmount)