# Alteryx designer Discussions

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.

 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

Thank you,

Highlighted
Alteryx Partner

A Multi-Row will solve this :)

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.