Perform a cumulative sum per month/quarter/year

[gujodm]

Hi, I have this raw data:

I want to create another column with the cumulative sum of the members per month/quarter/year, as example per month should be like this:

1,
3,
4,
6,
10,…etc.

Any suggestion? Thanks in advance.

[ScottF]

Maybe something like this helps get you started, using the GroupBy node (with count aggregation) and the Moving Aggregation node (with cumulative option checked, and sum for aggregation).

Afterward I leave it to you to figure out how best to join the branches back together, if that’s needed.

GroupedCumulativeSumExample.knwf (13.4 KB)