Hello, I have the below data: KNIME_project5.knwf (4.6 KB) I want to reach “result” column which depends on x,y and z columns. “result” column is constructed like that: First, x is the grouping variable y is the sorting variable(ascending) z is summing column Then, So for each goup(x), z is cumulative sum according to ascending y. How can I do this using Knime. I will be very glad for any help. Thanks a lot.

Hi @statman Please find below a generic alternative solution that doesn’t need loops to provide the same results, although it is mathematically more involved to understand :wink: : 20200620 Pikairos Cumulative sum of consequent numbers in each group.knwf (43.5 KB) [20200620 Pikairos Cumulative sum of consequent numbers in each group] The workflow is commented to make it easier to understand. Hope this is of help :smile: All the best Ael

Cumulative sum of consequent numbers in each group

KNIME Analytics Platform

statman June 20, 2020, 1:15pm 2

I found it:

1 Like