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

[gc-804]

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 solution]

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 solution]

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

[gc-804]

This worked exactly the way I want. Thank you both so much for your help!!

[Qiu]

@gc-804 

Thank you for your feedback and good to know it works.