We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Sum based on criteria

thomasgibbini
5 - Atom

Hello,


How can I group/sum 2 columns (Qtd and Sum)  based on first column criteria ? 

For example for the first row I have to sum/group the quantity and the values of account 3011 + 3016 and for the next row 3012+3017 and so on as picture below.

 

Thanks in advance.

thomasgibbini_1-1678826803296.png

 

 

3 REPLIES 3
BS_THE_ANALYST
15 - Aurora
15 - Aurora

.

 

All the best,
BS

LinkedIN

Bulien
BS_THE_ANALYST
15 - Aurora
15 - Aurora

@thomasgibbini actually think I had a logic flaw on previous response, ignore that one. I think this is closer to what you're looking for:

BS_THE_ANALYST_0-1678835115048.png

 

 

All the best,
BS

LinkedIN

Bulien
thomasgibbini
5 - Atom

That worked. Thanks a lot :)

Labels
Top Solution Authors