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,
Solved! Go to Solution.
Thanks a ton!!! I really appreciate it.
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
Thanks a lot!!!