How to perform repetitive aggregation over a field in a SAP HANA table?

The logic is pretty simple. You can define a local variable which is used for storing the total sum of all the groups. When you are performing iteration for each group, you can add the sum at the group level to the local variable.

I am not suggesting code as it is very basic and straightforward.