Include new field with subtotals/status in load script
I have a table, which includes Claim#, Date of payment and amount payed.
I would like to add a field, which adds up all the payments for a certain claim, and puts the results as an "Amount payed upto now" in a separate field, which I would like to call "Sub". See example below. How would I go about this in the load script?