https://community.qlik.com/t5/App-Development/Cumulative-sum-of-a-column-based-on-another-columns-in/m-p/1752431#M57963 <P>you need an expression something like this</P><P>=Aggr(RangeSum(Above(Sum(sales), 0, RowNo())), category, (date, (NUMERIC))).</P><P>attached output from my&nbsp; sample data<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/42266i367F68C6BB6E2D07/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P>&nbsp;</P> Wed, 14 Oct 2020 13:23:54 GMT dplr-rn 2020-10-14T13:23:54Z https://community.qlik.com/t5/App-Development/Cumulative-sum-of-a-column-based-on-another-columns-in/m-p/1752405#M57960 <P>I have to get cumsales field by the summation of sales for months and cum_category_count should be the cumulative count of category with respect to category and month. Could anyone please suggest a solution for this?</P> Wed, 14 Oct 2020 12:42:03 GMT https://community.qlik.com/t5/App-Development/Cumulative-sum-of-a-column-based-on-another-columns-in/m-p/1752405#M57960 freceena 2020-10-14T12:42:03Z https://community.qlik.com/t5/App-Development/Cumulative-sum-of-a-column-based-on-another-columns-in/m-p/1752431#M57963 <P>you need an expression something like this</P><P>=Aggr(RangeSum(Above(Sum(sales), 0, RowNo())), category, (date, (NUMERIC))).</P><P>attached output from my&nbsp; sample data<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/42266i367F68C6BB6E2D07/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P>&nbsp;</P> Wed, 14 Oct 2020 13:23:54 GMT https://community.qlik.com/t5/App-Development/Cumulative-sum-of-a-column-based-on-another-columns-in/m-p/1752431#M57963 dplr-rn 2020-10-14T13:23:54Z