Rolling 12 months

[#1]

Hi,

I having some problem in rolling 12 months, means here each and every month should have sum of preceding 12 months value.

For example July 2015 to June 2016, July 2015 value should be preceding 12 months and Aug 2015 also should have preceding 12 months.

Can any one help me here?

[Anonymous]

Hi,

Try with this expression and modify your fields accordingly

Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=MonthStart(Max(Date), -11))<=$(=Date(Max(Date)))’}>} Sales )

Hope it helps!!

[sunny_talwar]

May be like this:

RangeSum(Above(Sum(Sales), 0, 12))

You might have to change Above to Below based on your sorting.

[#4]

Hi,

Thanks for you guys response,

But my point not from July 2015 to June 2016  range sum and only rolling 12 months.

Actually rolling 12 month should be like this which I have mentioned below.

July 2015 = sum of Aug 2014 to July 2015

Aug 2015 =  sum of Sep 2014 to Aug 2015

            .

            .

June 2016= sum of July 2015 to June 2016.

But Format should be July 2015 to June 2016.

[sunny_talwar]

Format should be July 2015 to June 2016?? I am not sure I understand, can you may be provide a sample with the expected output?

[#6]

I have wrote the formula for this

rangesum(above(sum({<CalendarMonthName=,FiscalYear={'$(=max(FiscalYear))'}>}[Hours_12Mths]),0,12))

But I Want like above diagram.

[sunny_talwar]

Try this:

RangeSum(Above(Sum({1} [Hours_12Mths]), 0, 12)) * Avg({<CalendarMonthName=,FiscalYear={'$(=max(FiscalYear))'}>} 1)

[#8]

Hi Sunny,

Thanks for your reply, I have used your expression even though, its not working.

If any one knows, please give me proper solution for this requirement