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 |
