Cumulative sum

[#1]

Hi Community,

PFA

how to calculate cumulative sum..

Thanks in Advance

[Gysbert_Wassenaar · Accepted solution]

You can calculate it in the script like this:

Table:

LOAD [customer Id],

     product,

     D.O.P,

     [Bill Amount],

     Region,

     rangesum([Bill Amount],peek('Cumulative')) as Cumulative

FROM

comm95418.xlsx

(ooxml, embedded labels, table is Sheet1);

If you want to do it with an expression in a chart you can use rangesum(above(total sum([Bill Amount]),0,RowNo(total)))

[#3]

Hi

for straight table u can use accumulation in expression tab.

use rangesum and above functions

rangesum(above(total sum({1}Amount),0,3))

[sudeepkm]

As Aryabrahma mentioned you can use the Full accumulation in the Chart Expression properties. As shown below.