Accumulated Sum

[Shank]

Hi All,

I need to calculate the accumulated SUM for next four weeks. but i am facing little difficulty to achieve it could some one help on this.

Below is the scenario and i am looking for Accumulated Sum column to be calculated and logic is in Remarks

YearWeek	Mat	Ex_Mat	Sum	Accumulated Sum	Remarks
202044	1	A	100	1047	Running Sum of week Year 202045-202048
202045	1	A	150	1249	Running Sum of week Year 202046-202049
202046	1	A	125	1236	Running Sum of week Year 202047-202050
202047	1	A	314	922	Running Sum of week Year 202048-202050
202048	1	A	458	587	Running Sum of week Year 202049-202050
202049	1	A	352	600	Running Sum of week Year 202050
202050	1	A	112	0	Zero as we don’t have value
202044	1	B	123	1194	Running Sum of week Year 202045-202048
202045	1	B	365	953	Running Sum of week Year 202046-202049
202046	1	B	452	1025	Running Sum of week Year 202047-202050
202047	1	B	112	913	Running Sum of week Year 202048-202050
202048	1	B	265	648	Running Sum of week Year 202049-202050
202049	1	B	124	524	Running Sum of week Year 202050
202050	1	B	524	0	Zero as we don’t have value

[atcodedog05]

Hi @Shank 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05 · Accepted solution]

Hi @Shank 

I just did a cross validation.

Your below accumulated sum are wrong it doesnt match the remark too.

Hope this helps 🙂

[Qiu]

@Shank 
I think MultiRow Tool is what we need here.

R1: Added the sort to be sure.

[atcodedog05]

Happy to help 🙂 @Shank 

Cheers and Happy Analyzing 😀

[Shank]

@atcodedog05 Thanks for the solution

[Qiu]

@Shank 
Warm note. Multiple acceptance is allowed.😁