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 |
Solved! Go to Solution.
You can do this using the Multirow formula, please check the configuration below