multi row formula

Sarath27

Hi All,

Group the Levelling Key - then whichever the line has greater "Total" value then that respective Product of that line should be populated in both the lines.

Levelling Key	Product	Count	Sum_Level 1	Sum_Level 2	Sum_Level 3	Total	Group_ID	Right_Group_ID
BSP627819839-7758Debt Securities (Trading)0012530002	Bond - Corporate	4	0	33.61	0	33.61	399	399
BSP627819839-7758Debt Securities (Trading)0012530002	Government bond - US - coupon bearing	11	0	8707994	0	8707994	399	399

acotta17

Hi @Sarath27,

In addition to using the Multi-Row Formula tool, you could also follow the method outlined in the attached workflow. 

solution_levellingkeyAndProduct.yxmd