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!
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.