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,
Hi!
Welcome to Alteryx! You may want to post this to the Alteryx Designer location in the Community as this is not particularly relevant to Server deployments. That said, you may be interested in Batch Macros and how they work. I believe you may want to employ a Batch Macro to solve this problem.
Cheers,
Paulteryx