Finding cumulative value in a straight table

[#1]

Dear Friends,

I need a help in finding cumulative value in a straight table for the attached QVW file.

I wanted to find the cumulative values based on ID levels.

Result should be like the below:  (Based on the ID the cumulative values will be)(this sample is from Excel)

Regards,

Pooja.

[trdandamudi]

Give a try on the below expression for Cumulative:

RangeSum( Above(Sum(AMOUNT),0,RowNo()) )

[#3]

Hi Thiru,

Thanks for the response. For this example the given script is working fine but when i add the date column, it's not giving me the correct answer. PFA updated QVW file with the updated data.

Please help me if you can.

Thanks,

Pooja

[Anonymous]

try to create a field like this

Autonumber(ID&'-'&DATE&'-'&NAME&'-'&AMOUNT,ID) as Key

then use this in your expression :

Rangesum(above(total sum(AMOUNT),0,Key))

[qliksus · Accepted solution]

I guess your question has been answered in the some other thread . You can use the below

RangeSum( Above(total Sum(AMOUNT),0,RowNo(total )) )