How to accumulate value in rows with given conditions and return value in each row?

Question

Hello,

I want to insert a Formula to accumulate the Amount for the same Member in the same Company and return the calculation result in each row. See example below. If the same Member changed to a different Company in any given period, the accumulation starts from 0 in the new Company. The expected results are placed in column "Accumulated".

Could anyone help with this scenario without using macros?

Thank you in advance.

DataNath · Accepted Answer

Hey @gc-804, whilst this could be done with a Multi-Row Formula, the quickest way is to actually just use the Running Total tool. Within the configuration, you can set what you want this grouped by i.e. when to reset. The following gets you your desired output:

Qiu · Accepted Answer

@gc-804 
The Running Total tool is exactly for this purpose. 😁