Latest month with sales

[Anonymous]

Hi,

I want to calculate the latest month with sales in an expression in Qlik Sense.

How do I do that?

Year Month	Sales	Lastest Month with sales
2016 - Jan	400	120
2016 - Feb	500	120
2016 - Mar	400	120
2016 - Apr	120	120
2016 - May	0	120
2016 - Jun	0	120
2016 - Jul	0	120

Best Regards,

Thomas