Start Free Trial

Alteryx Designer Desktop Discussions

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

Formula of combining three rows and replace the 3 rows with the new row

Kaustubh17
9 - Comet

Hi Team,

 

i have facing problem of solving the formula. i have 3 rows such as 

1   2   3

A -10-45

B-15-45

C-34-45

D-76-344

E-78-34

 

1,2,3 are fields and A to E are rows and in front of that we have data.

 

I want B+C+D which is Z now i don't want B,C,D row in the final output. i want the Z row with is Sum of B,C,D.

1  2    3

A-10-45

Z- Sum of B,C,D

E-78-24

 

if you have any doubt please let me know how i can resolve that.

 

Thanks,

Kaustubh

1 REPLY 1
binu_acs
21 - Polaris

@Kaustubh17 One way of doing this

image.png

Labels
Top Solution Authors