cumulative sum

ysreenumba

Hi All,

I have employee data deptno,ename,sal and i want output like below. 

i can get output in oracle using partition but how to solve using alteryx.

deptno,ename,sal,CUMDEPTTOT,DEPTTOTAL,CUMTOT,TOTSAL

using summary tool i got totsal but unable to join as there is no common column in totsal output. pls help me

Thanks

sreeni

Emp_Cumm_Sal.yxmd

emppipe.txt

andyuttley

Hi @ysreenumba 

If I've understood correctly, the workflow below and attached should give you what you need:

Let me know if not! Hope this helps

Andy

CumulativeTotal.yxzp