Next 11 months cumulative sum

[miskin_m]

Hi All,

Need help to calculate next 11 cumulative sum. I did not want to use the rangesum below since it is restricted to the dimension value in chart.

EG: if Apr 17 then it shld be from Apr 17 to Feb 18.

Need solution at the back end. I have already used the as of table but it works with rolling last month.

Regards

[Anil_Babu_Samineni]

If you select Apr 17 - How you are getting data in script? BTW, You are seeing those affections in design. Why are you looking in script.

[miskin_m]

Hw u will do it at front end. I need the 13 months in the chart and for each month it shld calculate its respective next 11 month sales. 

[Anil_Babu_Samineni]

If Jan-18 selected, What is the expected result? And How much data you have for forecast, if any?