Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Running 10 rows total

Highlighted
Meteoroid

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.

 

RecordIDFinal DestDateContainer CountDesired Output
1A4/24/201959
2A4/25/201904
3A4/26/201904
4A4/27/201917
5A4/28/2019011
6A4/29/2019311
7A4/30/201908
8A5/1/201909
9A5/2/201909
10A5/3/2019010
11A5/4/2019019
12A5/5/2019019
13A5/6/2019319
14A5/7/2019516
15A5/8/2019011
16A5/9/2019011
17A5/10/2019111
18A5/11/2019010
19A5/12/2019110
20A5/13/201999
21B4/16/2019111
22B4/17/2019110
23B4/18/201909
24B4/19/201909
25B4/20/2019212
26B4/21/2019010
27B4/22/2019210
28B4/23/2019013
29B4/24/2019014
30B4/25/2019514
31B4/26/201909
32B4/27/201909
33B4/28/201909
34B4/29/201939
35B4/30/201906
36B5/1/201906
37B5/2/201956
38B5/2/201911
39B5/3/201900
40B5/4/201900

 

Could you please help me in solving this problem?

 

Thank you,

Highlighted
Alteryx Partner

A Multi-Row will solve this :)

 

2019-04-17 06_51_18-Alteryx Designer x64 - running 10 rows.yxmd.png

Highlighted
Meteoroid

Thanks a ton!!! I really appreciate it.

Asteroid

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

Highlighted
Meteoroid

Thanks a lot!!!

Labels