Running Sum of next 4 Weeks

[Shank]

Hi All,

I am facing an issue where i need to calculate the Accumulated Sum for next 4 weeks (current week Should be excluded). can some one help how can i achieve this? Below is the example on how i need to calculate Accumulated Sum (Refer to Remarks column)

YearWeek	Mat	Ex_Mat	Sum	Running 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

[Amarendra · Accepted solution]

You can do this using the Multirow formula, please check the configuration below