Rolling 12-months since last month

nesonica — Sat, 16 Nov 2024 04:14:48 GMT

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)

Re: Rolling 12-months since last month

bobbydave — Thu, 07 Mar 2019 14:41:41 GMT

=Sum({<PeriodMath={'>=$(=Monthstart(addmonths(max(Today()),-11)))<=$(Monthstart(addmonths(max(Today()),-1))'}>} Sales)