Summing up values by ID's

[Rsaiq]

Hi All,

I have 3 scriptID in my dataset as 1,2 and 3.

I am doing sum row by row per scriptID using range sum.You can see below in my table there are ScriptID's with their values.I need sum total as per ScriptID's(please refer screenshot below).

But i am getting all amount suming up without looking scriptID.

Can anyone have idea how to do sum like this through scripts.

Used below scripts in my application:-

Test:
load *,
RangeSum(Peek('NewValue'),Value) as NewValue;

LOAD
ScriptID,
Value,
"Date"
FROM [lib://AttachedFiles/SampleData.xlsx]
(ooxml, embedded labels, table is Sheet2);

Please find attached sample data file.

Thanks 

[Rsaiq · Accepted solution]

Achived what i wanted with previous function
if(previous(ScriptID) = ScriptID, rangesum(peek('NewValue'), Value),Value) as NewValue

Thanks