Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Running Sum of next 4 Weeks

Shank
8 - Asteroid

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)

 

YearWeekMatEx_MatSumRunning SumRemarks
2020441A1001047Running Sum of week Year 202045-202048
2020451A1501249Running Sum of week Year 202046-202049
2020461A1251236Running Sum of week Year 202047-202050
2020471A314922Running Sum of week Year 202048-202050
2020481A458587Running Sum of week Year 202049-202050
2020491A352600Running Sum of week Year 202050
2020501A1120Zero as we don’t have value
2020441B1231194Running Sum of week Year 202045-202048
2020451B365953Running Sum of week Year 202046-202049
2020461B4521025Running Sum of week Year 202047-202050
2020471B112913Running Sum of week Year 202048-202050
2020481B265648Running Sum of week Year 202049-202050
2020491B124524Running Sum of week Year 202050
2020501B5240Zero as we don’t have value
1 REPLY 1
Amarendra
10 - Fireball

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

 

Screen Shot 2020-10-26 at 11.04.49 AM.png

 

Labels