topic Re: Monthly Rolling data... in QlikView https://community.qlik.com/t5/QlikView/Monthly-Rolling-data/m-p/310453#M114620 <HTML><HEAD></HEAD><BODY><P>Hard for me to say exactly without looking at your example, but here is an exmaple of how I get cumulative amount billed in one of my applications:</P><P></P><P>=rangesum(above([Commercial Billed],1,rowno()))+[Commercial Billed]</P><P></P><P>Hopefully if you just take out commercial billed and put in amount collected to date, it will work</P><P></P><P>Edit: this assumes your data is sorted from oldest to newest</P></BODY></HTML> Wed, 22 Jun 2011 18:10:18 GMT 2011-06-22T18:10:18Z Monthly Rolling data... https://community.qlik.com/t5/QlikView/Monthly-Rolling-data/m-p/310452#M114619 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P></P><P>A genral Query: In a Pivot, I have <STRONG>YearMonth</STRONG>&nbsp; as <STRONG>Dimension</STRONG> which is in the format of 2011-01, 2011-02 and so on. I have a <STRONG>Amount Collected This month </STRONG>expression column which is a combination of 2 variables <STRONG>$(vAmount)+$(vInterest). </STRONG>Now I need to do a rolling yearly calculation for the field <STRONG>Amount Collected To Date</STRONG>, which is the sum of previous months amounts... rolling.</P><P></P><P>Thanks in Advance</P></BODY></HTML> Wed, 22 Jun 2011 11:51:14 GMT https://community.qlik.com/t5/QlikView/Monthly-Rolling-data/m-p/310452#M114619 2011-06-22T11:51:14Z Re: Monthly Rolling data... https://community.qlik.com/t5/QlikView/Monthly-Rolling-data/m-p/310453#M114620 <HTML><HEAD></HEAD><BODY><P>Hard for me to say exactly without looking at your example, but here is an exmaple of how I get cumulative amount billed in one of my applications:</P><P></P><P>=rangesum(above([Commercial Billed],1,rowno()))+[Commercial Billed]</P><P></P><P>Hopefully if you just take out commercial billed and put in amount collected to date, it will work</P><P></P><P>Edit: this assumes your data is sorted from oldest to newest</P></BODY></HTML> Wed, 22 Jun 2011 18:10:18 GMT https://community.qlik.com/t5/QlikView/Monthly-Rolling-data/m-p/310453#M114620 2011-06-22T18:10:18Z