Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Create a Running Total Table

YLYONG
9 - Comet
‎08-16-2022 09:54 PM

Hi Alteryx Community,

 

Wanting to get your help on turning below table into a running total table:

 

Thank you!

 

INPUT TABLE:

 

FRUITSSum_FRESH STOCKSum_WeeksAVG WEEKLY FRESH STOCK
APPLES                                           123                                                              8                                                     15
BANANAS                                     10,924                                                              8                                               1,365
ORANGE                                     61,068                                                              8                                               7,633
STRAWBERRY                               1,462,986                                                              8                                           182,873

 

 

OUTPUT TABLE:

 

FRUITSWEEKRUNNING TOTAL_FRESH STOCK
APPLES1                                                            15
APPLES2                                                            31
APPLES3                                                            46
APPLES4                                                            62
APPLES5                                                            77
APPLES6                                                            92
APPLES7                                                          108
APPLES8                                                          123
BANANAS1                                                      1,366
BANANAS2                                                      2,731
BANANAS3                                                      4,097
BANANAS4                                                      5,462
BANANAS5                                                      6,828
BANANAS6                                                      8,193
BANANAS7                                                      9,559
BANANAS8                                                    10,924
Labels:
Reply
0 Likes
1 REPLY 1
kathleenmonks
Alteryx Alumni (Retired)
‎08-17-2022 09:40 AM

Hi @YLYONG , 

 

I believe this is a duplicate to your other community question, see my solution here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Create-a-Running-Table/td-p/984539

 

Reply
0 Likes
Community Live Fifa Workshop
Labels
Top Solution Authors
View All