Alteryx Designer Desktop Discussions

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

Summarize Multiple columns into 1

stevelogue1980
8 - Asteroid

Hi Alteryxians, 

3 years sales should summarize as 1 output

Sample Input: (excel attached)

stevelogue1980_0-1667520741116.png

 

Expected Output:

stevelogue1980_1-1667520741221.png

 

Please find the workflow& excel input attached

3 REPLIES 3
Felipe_Ribeir0
16 - Nebula

Hi @stevelogue1980 

 

One way of doing this dinamically

 

Felipe_Ribeir0_0-1667521501455.png

 

 

grazitti_sapna
17 - Castor

@stevelogue1980 , Please find another way of doing it.

 

grazitti_sapna_0-1667539247437.png

 

Sapna Gupta
DenisZ
11 - Bolide

@stevelogue1980 , please find my solution. Hope its helpful. 

 

DenisZ_0-1667543036846.png

 

Labels