Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I have a bar chart and I would like to always present 12 month depending on selection in Years and Months.
If I select Year = 2017 and Month = 05 I would like to see --> would like to see month from 201605-201704
Regards Mikael
Sum({$<Month=, Year=, Date={">=$(=MonthStart(AddMonths(Max(Date),-12)))<$(=MonthEnd(Max(Date)))"}>} Sales)
Hi Mikael,
If I understood correct, next statement has to be work.
Sum({$<Month=, Year=, Date={">=$(=MonthStart(Min(Date)))<$(=MonthEnd((AddMonths(Min(Date)), 12))"}>} Sales)