https://community.qlik.com/t5/App-Development/Calculate-cumilative-sum-for-date/m-p/1514639#M36827 <P>Within a table you can use</P><P><SPAN>RangeSum(Above(Sales,0,999)) </SPAN></P> Fri, 30 Nov 2018 07:24:21 GMT jfkinspari 2018-11-30T07:24:21Z https://community.qlik.com/t5/App-Development/Calculate-cumilative-sum-for-date/m-p/1514620#M36826 <P>Hi,</P><P>I want to calc cumilative &nbsp;sum of sales , mentioned as desired output in the below table</P><TABLE><TBODY><TR><TD>&nbsp;</TD><TD>Date</TD><TD>Sales</TD><TD>Desired Output</TD></TR><TR><TD>Min Date</TD><TD>11/25/2018</TD><TD>50</TD><TD>50</TD></TR><TR><TD>&nbsp;</TD><TD>11/26/2018</TD><TD>46</TD><TD>96</TD></TR><TR><TD>&nbsp;</TD><TD>11/27/2018</TD><TD>67</TD><TD>163</TD></TR><TR><TD>&nbsp;</TD><TD>11/28/2018</TD><TD>42</TD><TD>205</TD></TR><TR><TD>&nbsp;</TD><TD>11/29/2018</TD><TD>38</TD><TD>243</TD></TR><TR><TD>&nbsp;</TD><TD>11/30/2018</TD><TD>25</TD><TD>268</TD></TR><TR><TD>Max Date</TD><TD>12/1/2018</TD><TD>61</TD><TD>329</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Appreciate your help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 30 Nov 2018 06:41:07 GMT https://community.qlik.com/t5/App-Development/Calculate-cumilative-sum-for-date/m-p/1514620#M36826 siddharthsoam 2018-11-30T06:41:07Z https://community.qlik.com/t5/App-Development/Calculate-cumilative-sum-for-date/m-p/1514639#M36827 <P>Within a table you can use</P><P><SPAN>RangeSum(Above(Sales,0,999)) </SPAN></P> Fri, 30 Nov 2018 07:24:21 GMT https://community.qlik.com/t5/App-Development/Calculate-cumilative-sum-for-date/m-p/1514639#M36827 jfkinspari 2018-11-30T07:24:21Z https://community.qlik.com/t5/App-Development/Calculate-cumilative-sum-for-date/m-p/1514701#M36828 Or may be like this:<BR />Rangesum(above(Sales, 0, RowNo(Total))) Fri, 30 Nov 2018 09:16:22 GMT https://community.qlik.com/t5/App-Development/Calculate-cumilative-sum-for-date/m-p/1514701#M36828 Frank_Hartmann 2018-11-30T09:16:22Z