How to sum specific records using multi row formula tool

[anonymous008_G]

Hi Guys - 

Can someone please help me to know how would i perform sum calculation in below table. I want to sum values for governement,materials, Real Estate and Not classified and create new field as Other. this calculation to be perform different for Fund and BM. 

Input table :- 

Sector	Fund %	BM %
Communications	10	15
Consumer Staples	20	30
Energy	30	45
Financials	40	60
Government	50	75
Industrials	60	90
Materials	70	105
Real Estate	80	120
Utilities	90	135
Not Classified	100	150

Expected Output as per attached screenshot

[davidskaife · Accepted solution]

Hi @anonymous008_G 

Here is one way - flag the rows that need to be summed using a Formula tool, then Summerize, filter out only the true records, create an 'Other' field, rename and remove fields not required, and Union back to the original stream

[anonymous008_G]

@davidskaife thanks. This works awesome