Rolling Month Sum

[aslam24196]

Hi guys,

I needed rolling sum of current year for 12 months, if there are less than 12 months available, it should take how much ever months are remaining from the previous year column. I did achieve this in a text box for result. In my application, when I click a MonthYear, the text box displays the corresponding Rolling Sum. However, I need this in a straight chart, with MonthYear as Dimension and Rolling month in its corresponding expressions column. I have attached the qvw just in case. There is text object. I need the values of that in the chart. If possible in the backend, please guide me.

Thank you guys.

[aslam24196 · Accepted solution]

Thanks sudhir for the help. I played around for sometime and I did it. Yes what you did was correct. But it also needs the Rangesum of remaining months prom PY. I'll attach the file..

Thank you,

Cheers!

[aslam24196]

[sudhirpkuwar]

Good that you solved it....