Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I would like to know if it is possible to automatically calculate last 6 months based on my selected month:
For example if i choose Jan 2016
How can I get make my graph automatically to show:
janv-2016
Dec-2015
Nov-2015
Oct-2015
Sept-2015
Aug-2015
Any idea?
Many Thanks,
Hasvine
Hi,
Try this expression
=Sum({<Month={'>=$(=Max(Month) - 5)<=$(=Max(Month))'}>}Amount)
Regards,
Jagan.
if you need include selected month use this:
=Sum({<Month={'>=$(=Max(Month) - 5)<=$(=Max(Month))'}>}Amount)
Helpful. Thanks.
Hi Jonathan,
Actually my real dates are in DD/MM/YYYY so do I need to seperate the Year?
Thanks,
Hasvine