Summarize rows in sequence groups

[Alchemist360]

Dear Alteryx community,

I have the below requirement. Please let me know of a possible solution.

Input:

Row No	Supplier	Month	Cost
1	A	10/1/2024	100
2	A	11/1/2024	200
3	A	12/1/2024	300
4	A	1/1/2024	400
5	A	2/1/2024	500
6	A	3/1/2024	600
7	A	4/1/2024	700
8	A	5/1/2024	800

Required Output

Sum of Rows	Supplier	Sum of Cost
123	A	600
234	A	900
345	A	1200
456	A	1500
567	A	1800
678	A	2100

[Raj]

@Alchemist360 
multi row formula will help to achieve this.

[Raj · Accepted solution]

@Alchemist360 
please find the workflow attached 
mark done if solved.

[Alchemist360]

Thanks much for the solution. I was thinking that the Row operation can go 1 row up or 1 row down.  Thank you again!

[Raj]

@Alchemist360 
happy to help.