Hi Alteryx Community,
Wanting to get your help on turning below table into a running total table:
Thank you!
INPUT TABLE:
FRUITS | Sum_FRESH STOCK | Sum_Weeks | AVG 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:
FRUITS | WEEK | RUNNING TOTAL_FRESH STOCK |
APPLES | 1 | 15 |
APPLES | 2 | 31 |
APPLES | 3 | 46 |
APPLES | 4 | 62 |
APPLES | 5 | 77 |
APPLES | 6 | 92 |
APPLES | 7 | 108 |
APPLES | 8 | 123 |
BANANAS | 1 | 1,366 |
BANANAS | 2 | 2,731 |
BANANAS | 3 | 4,097 |
BANANAS | 4 | 5,462 |
BANANAS | 5 | 6,828 |
BANANAS | 6 | 8,193 |
BANANAS | 7 | 9,559 |
BANANAS | 8 | 10,924 |
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