Rolling cumulative sum by groups of column entries
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? NameTypevaluecumulative sumAAAT111AAAT11011AAAT13243AAAT1447AAAT222AAAT235AAAT2510AAAT2616BBBT13232BB...