Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

cumulative sum

ysreenumba
7 - Meteor

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

 

2 REPLIES 2
andyuttley
11 - Bolide
11 - Bolide

Hi @ysreenumba 

 

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

 

Totals.PNG

 

 

Let me know if not! Hope this helps

Andy

ysreenumba
7 - Meteor

@andyuttley  Thanks for your help.

Labels