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

[andyuttley · Accepted solution]

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

[ysreenumba]

@andyuttley  Thanks for your help.