Show last 3 months of sales in Qliksense

[sandhyag]

Hello All, 

I have got a requirement to show last three months of sales. 

I have a column called MonthYear which shows month with year and I have a measure called revenue. When I select a monthyear filter for example when I select feb 2020 then it has to show me Jan 2020, nov and dec,2019 data in the sheet. 

Help needed. 

Thanks

[JuanGerardo]

Hi @sandhyag, maybe you can use something like this:

Sum({<MonthYear={">$(=Max(MonthYear) - 4)<$(=Max(MonthYear))"}>} Revenue)

JG