Range Sum using peek

[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.I have a requirement as below

You can see below in my table there are ScriptID's with their values.So i need sum for ScriptID=1 as (5+5+5+5)=20,ScriptID=2 as (10+10+10+10)=40 and ScriptID=3 as (20+20+20+20)80(Please refer sccreenshot 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