Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I would like to show Sales as standard for the sum of the last month until the last 12 months before that.
i know have it on a yearly level:
=Sum({<PeriodMath={'>=$(vMinPeriodYear2)<=$(vMaxPeriod2)'}>} Sales)
=Sum({<PeriodMath={'>=$(=Monthstart(addmonths(max(Today()),-11)))<=$(Monthstart(addmonths(max(Today()),-1))'}>} Sales)
=Sum({<PeriodMath={'>=$(=Monthstart(addmonths(max(Today()),-11)))<=$(Monthstart(addmonths(max(Today()),-1))'}>} Sales)