Rolling cumulative sum by groups of column entries

dileepkr

Hi,

 

I am trying to create the cumulative sum column as shown in the table below. 

When I use the Col cumulative sum( value) directly, it gives cumulative sum for entire value column. Can anyone please help me understand how to calculate the cumulative sum for groups of Type as shown in table below?

 

Name	Type	value	cumulative sum
AAA	T1	1	1
AAA	T1	10	11
AAA	T1	32	43
AAA	T1	4	47
AAA	T2	2	2
AAA	T2	3	5
AAA	T2	5	10
AAA	T2	6	16
BBB	T1	32	32
BBB	T1	34	66
BBB	T1	5	71
BBB	T1	67	138
BBB	T2	34	34
BBB	T2	32	66
BBB	T2	7	73
BBB	T2	8	81

 

txnelson

Use the by capability within the Col Cumulative Sum() function.

col cumulative sum(:value, :Name, :Type);