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

Sum up specific rows

BosKev
8 - Asteroid

Hi All,

 

I'm looking for a formula or tool that can sum up rows depend on a condition.

 

example below I want to sum up market C and D and have the new sales be the total of the 2 markets, any suggestions? Thanks.

 

Market SalesNew Sales
A274274
B300300
C486848
D362848
E493493
F193193
2 REPLIES 2
Aaron_Harter
11 - Bolide

Hi @BosKev,

 

Consider using a Join to separate these data points into a new stream, then map them back into the table once the "New Sales" are calculated:

4.PNG 

BosKev
8 - Asteroid

Very creative, thank you!

Labels