Rolling 12-months since last month

[nesonica]

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)

[bobbydave · Accepted solution]

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