Cumulative sum based on the multiple id.

[sriniprad08]

Hi Team,

Hope you are well. I need help. 

I need to sum the values of a column based on the id. Final output column is marked in yellow.

Thanks ,

Sri

[geraldo · Accepted solution]

@sriniprad08 

This is your sample as a sub_num I thought there was something wrong with the calculations. If so, could you explain the formula?

I put a view of mine below in the print.

[sriniprad08]

Hi @geraldo thank you. sorry your point is correct. it should be what you marked in red.

[geraldo · Accepted solution]

@sriniprad08 

to have a result I did the sub_num my way

[caltang]

@sriniprad08 - @geraldo ‘s solution is more elegant. Go with his, it will solve your need.

[sriniprad08]

Thank you @caltang  Appreciate all your help

[sriniprad08]

Thank you @geraldo . Great help. Appreciate.

[caltang]

Happy to have contributed! Cheers man