Addition of one row to another.

[anonymous008_G]

Hi  - I need one help in the below scenario in Alteryx. I wanted to merge/add "Not classified" data into the row which has highest Gross exposure. For example Maturity(,1) has largest exposure in the Gross column. so this Not classified should be get added in the same bucket. Incase in the next reporting Maturity[3,5) has largest exposure then it should merge/add into this bucket. Can someone please guide me, how can achieve this using Alteryx.

Sector	Gross	Net
Maturity(,1)	60	30
Maturity[1,3)	40	35
Maturity[3,5)	35	25
Maturity[5,7)	5	5
Maturity[7,10)	0	0
Maturity[10,)	0.5	0.6
Not Classified	0.27	0.27

[binuacs · Accepted solution]

@anonymous008_G something like the attached workflow?

[anonymous008_G]

@binuacs -- Thank you for the solution. This would partially work. Can this expression be changed to get the below output? Not classified Gross and Net values added in the respective Gross and Net where Gross is Maximum.

Sector	Gross	Net
Maturity(,1)	60.27	30.27
Maturity[1,3)	40	35
Maturity[3,5)	35	25
Maturity[5,7)	5	5
Maturity[7,10)	0	0
Maturity[10,)	0.5	0.6
Not Classified	0.27	0.27

[binuacs · Accepted solution]

@anonymous008_G updated workflow attached

[anonymous008_G]

@binuacs  Oh thanks i thought of this but i made wrong column order in formula tool. anyway thanks for your help.