Running 10 rows total

[lsharma]

Hi Alteryx Community,

I am new to the Alteryx and need your help on something which seems to be very easy task in excel.  

I would like to calculate the running total of 10 rows at a time.

RecordID	Final Dest	Date	Container Count	Desired Output
1	A	4/24/2019	5	9
2	A	4/25/2019	0	4
3	A	4/26/2019	0	4
4	A	4/27/2019	1	7
5	A	4/28/2019	0	11
6	A	4/29/2019	3	11
7	A	4/30/2019	0	8
8	A	5/1/2019	0	9
9	A	5/2/2019	0	9
10	A	5/3/2019	0	10
11	A	5/4/2019	0	19
12	A	5/5/2019	0	19
13	A	5/6/2019	3	19
14	A	5/7/2019	5	16
15	A	5/8/2019	0	11
16	A	5/9/2019	0	11
17	A	5/10/2019	1	11
18	A	5/11/2019	0	10
19	A	5/12/2019	1	10
20	A	5/13/2019	9	9
21	B	4/16/2019	1	11
22	B	4/17/2019	1	10
23	B	4/18/2019	0	9
24	B	4/19/2019	0	9
25	B	4/20/2019	2	12
26	B	4/21/2019	0	10
27	B	4/22/2019	2	10
28	B	4/23/2019	0	13
29	B	4/24/2019	0	14
30	B	4/25/2019	5	14
31	B	4/26/2019	0	9
32	B	4/27/2019	0	9
33	B	4/28/2019	0	9
34	B	4/29/2019	3	9
35	B	4/30/2019	0	6
36	B	5/1/2019	0	6
37	B	5/2/2019	5	6
38	B	5/2/2019	1	1
39	B	5/3/2019	0	0
40	B	5/4/2019	0	0

Could you please help me in solving this problem?

Thank you,

[cmcclellan · Accepted solution]

A Multi-Row will solve this :)

[lsharma]

Thanks a ton!!! I really appreciate it.

[CRowlatt · Accepted solution]

Hi Isharma,

Welcome to the community!

I believe I've recreated what you're after, the running total tool adds up a column up until the current row, where as you're looking at the current row plus the next 9 rows?

A multi-row formula (grouped by Final Dest) gives you your desired outcome.

Download my workflow and sub in your input and see if it works.

Chris

[lsharma]

Thanks a lot!!!