topic Re: Cumulative Sum based on preceding rows on a grid? in QlikView https://community.qlik.com/t5/QlikView/Cumulative-Sum-based-on-preceding-rows-on-a-grid/m-p/984169#M644776 <HTML><HEAD></HEAD><BODY><P>Create an expression like</P><P></P><P>=Rangesum( Above( Sum(costs), 0, RowNo() ))</P></BODY></HTML> Wed, 25 Nov 2015 16:42:06 GMT swuehl 2015-11-25T16:42:06Z Cumulative Sum based on preceding rows on a grid? https://community.qlik.com/t5/QlikView/Cumulative-Sum-based-on-preceding-rows-on-a-grid/m-p/984168#M644775 <HTML><HEAD></HEAD><BODY><P>Hello, so I have this grid that has two fields, one is a number of 'costs' per a 'department' lets say, and then another one for the cumulative costs as the department costs are listed under it (proceeding). Is there a script that can calculate the cumulative sum in such a way as to say in the first row take the cost, then in the second row, add both, then add all three in the third row? here's a pic for an idea!</P><P></P><P>Sum cum full will have .1647 on the first row, then the sum of (.1674+.2222) on the second row and so on!</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/107113_Capture.PNG" style="height: auto;" /></P><P></P><P>Thank you!</P><P>Kurt</P></BODY></HTML> Wed, 25 Nov 2015 16:18:20 GMT https://community.qlik.com/t5/QlikView/Cumulative-Sum-based-on-preceding-rows-on-a-grid/m-p/984168#M644775 2015-11-25T16:18:20Z Re: Cumulative Sum based on preceding rows on a grid? https://community.qlik.com/t5/QlikView/Cumulative-Sum-based-on-preceding-rows-on-a-grid/m-p/984169#M644776 <HTML><HEAD></HEAD><BODY><P>Create an expression like</P><P></P><P>=Rangesum( Above( Sum(costs), 0, RowNo() ))</P></BODY></HTML> Wed, 25 Nov 2015 16:42:06 GMT https://community.qlik.com/t5/QlikView/Cumulative-Sum-based-on-preceding-rows-on-a-grid/m-p/984169#M644776 swuehl 2015-11-25T16:42:06Z