Create a Running Table

[YLYONG]

Hi Alteryx Community,

Wanting to get your help on creating a running table:

Thankyou!

Input Table:

FRUITS	Sum_FRESH STOCK	Sum_Weeks	AVG WEEKLY FRESH STOCK
APPLES	123	8	15
BANANAS	10,924	8	1,366
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
ORANGE
ORANGE
ORANGE

[kathleenmonks · Accepted solution]

Hi @YLYONG,

Please see my attached screenshot and workflow. First generate additional rows for each week, then use a formula tool to calculate the running total. Let me know if this helps!

[YLYONG · Accepted solution]

@kathleenmonks 

Thank you, this is a very neat solution! 

I attempted (below) and get the intended output, and will replace them with your simpler solution.