topic How use RangeSUM in Pivot to SUM all before in App Development https://community.qlik.com/t5/App-Development/How-use-RangeSUM-in-Pivot-to-SUM-all-before/m-p/1860279#M70982 <P>Hi All,</P> <P>I have a problem, calculate accumulative sum's for some transactions in PIVOT.</P> <P>I am using formula&nbsp; RangeSum(Before(TOTAL sum([UseQTY]),0,ColumnNo(TOTAL)))</P> <P>I need to calculate all UseTOTAL till some period. I need calculate all periods even before the filter is used.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="irmantas_0-1637138106503.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66807i38197A3CBC5645FC/image-size/medium?v=v2&amp;px=400" role="button" title="irmantas_0-1637138106503.png" alt="irmantas_0-1637138106503.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="irmantas_1-1637138526500.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66808i22A7311E7E333F66/image-size/medium?v=v2&amp;px=400" role="button" title="irmantas_1-1637138526500.png" alt="irmantas_1-1637138526500.png" /></span></P> <P>&nbsp;</P> Wed, 17 Nov 2021 08:42:35 GMT irmantas 2021-11-17T08:42:35Z How use RangeSUM in Pivot to SUM all before https://community.qlik.com/t5/App-Development/How-use-RangeSUM-in-Pivot-to-SUM-all-before/m-p/1860279#M70982 <P>Hi All,</P> <P>I have a problem, calculate accumulative sum's for some transactions in PIVOT.</P> <P>I am using formula&nbsp; RangeSum(Before(TOTAL sum([UseQTY]),0,ColumnNo(TOTAL)))</P> <P>I need to calculate all UseTOTAL till some period. I need calculate all periods even before the filter is used.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="irmantas_0-1637138106503.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66807i38197A3CBC5645FC/image-size/medium?v=v2&amp;px=400" role="button" title="irmantas_0-1637138106503.png" alt="irmantas_0-1637138106503.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="irmantas_1-1637138526500.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/66808i22A7311E7E333F66/image-size/medium?v=v2&amp;px=400" role="button" title="irmantas_1-1637138526500.png" alt="irmantas_1-1637138526500.png" /></span></P> <P>&nbsp;</P> Wed, 17 Nov 2021 08:42:35 GMT https://community.qlik.com/t5/App-Development/How-use-RangeSUM-in-Pivot-to-SUM-all-before/m-p/1860279#M70982 irmantas 2021-11-17T08:42:35Z Re: How use RangeSUM in Pivot to SUM all before https://community.qlik.com/t5/App-Development/How-use-RangeSUM-in-Pivot-to-SUM-all-before/m-p/1860361#M70989 <P>Or I need use other expression?</P> Wed, 17 Nov 2021 10:16:29 GMT https://community.qlik.com/t5/App-Development/How-use-RangeSUM-in-Pivot-to-SUM-all-before/m-p/1860361#M70989 irmantas 2021-11-17T10:16:29Z