Need help with running sum

[Anonymous]

  Hey guys,

I am having issues  with this  I need to be able to  do this on a pivot chart as well as backend  script .  The last column adds the staff on site .  and sorts it by Arrival order   and groups by id.  Any help would be appreciated.  Thank you so much!

ID	Arrival_Order	StaffOnsite	Running Sum needed Column
10-0000313	4	3	3
10-0000313	5	3	6
10-0000401	3	3	3
10-0000401	4	3	6
10-2093202	1	4	4
10-2093202	2	6	10
10-2093202	4	9	19
10-2093202	5	2	21

[sunny_talwar]

May be this

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

[Anonymous]

Thanks, however when I add a column to this it stops the running total.  is there a way I can use the rangesum in script and pull from there?    i need it to reset when inci_no changes and arrival order rolls back to 1. 

ID	unit	Arrival_Order	StaffOnsite	Running Sum needed Column
10-0000313	2w	4	3	3
10-0000313	e31	5	3	6
10-0000401	d2	3	3	3
10-0000401	e2	4	3	6
10-2093202	41	1	4	4
10-2093202	24	2	6	10
10-2093202	xw2	4	9	19
10-2093202	xss	5	2	21

[sunny_talwar]

Try this

RangeSum(Above(TOTAL Sum(StaffOnsite), 0, RowNo(TOTAL)))

[Anonymous]

I ended up using

RangeSum(Above(TOTAL Sum(StaffOnsite), 0, arrival_order))   and that worked.. Thank you