Multiple Row Sum and statement Condition

[Tommy23]

Hello, 

I would like to Sum two value ( Revenue and Margin) and having a new row when it is wrote " Marge" with the result of the sum

Input:

Category	Number
Margin	333
Below EBID	2024
EBIT	2365
Revenue	650

I would like to sum Revenue and Margin (results will be 983 in the category Marge)

Thanks in advance for you help

Output:

Category	Number
Margin	333
Below EBID	2024
EBIT	2365
Revenue	650
Marge	983

[DataNath]

Hey @Tommy23 here's one way you could go about this - 

1) Isolate the rows of interest

2) Summarize to get the total

3) Add the new 'Category'

4) Union this new total back on to the main dataset