Max value over +/-5 rows

[pnre]

Hi i want to achieve a table like below. 

I have already the Sec and the value, and i want to create a new column thats takes the larges "value" from column 2 over +/- 5 rows as below.

How can i do that in alteryx? i have 44k rows

Sec	Value	Max over +/- 5 rows
1	2	4
2	2	9
3	3	9
4	3	9
5	4	9
6	5	9
7	9	9
8	3	9
9	4	9
10	7	9

[grchavarri]

Hi @pnre , 

you just have to configure the multi-row formula as the image below, increasing the values taken in the tool as you can see in the image. And then, you can use the formula max to get your result. 

Let me know with any issues.

Hope it helps.