HANA Scripted View How to add the quantity for each row value

[Former Member]

Hi Experts,

Please help me with the code in Scripted HANA View for the below requirement.

Requirement: I need to Populate the Calculated column based on Req Qty and Material.

For each material need to sum up all the quantities based on date.

Example: for Material Mat1 1st row it has to populate 10 in the calculated column,

And in the 2nd row it has to populate 40 in the calculated column i.e 30+10

Similarly in the 3rd row it has to populate 60 in the calculated column i.e 40+20

Like that I need to populate the calculate column in the below table.

RESBReq NoReq DateMaterialPlantReq QtyCalculated ColumnReq17/11/2017Mat150011010Req28/11/2017Mat150013040Req39/11/2017Mat150012060Req410/11/2017Mat1500150Req17/11/2017Mat250011010Req28/11/2017Mat250013040Req39/11/2017Mat2500120Req49/11/2017Mat2500130Req56/11/2017Mat2500110

[Former Member]

Please find the table below for reference.