How to add a row to get a difference between columns of data

[cfine]

I have got the following file I am trying to take the difference between each Type for Cost, Interest and MTM.  I am not sure how best to accomplish this.  

RecordID	Type	Cost	Interest	MTM
1	Type 1	125	125
2	Type 1	100	100
3	Type 2	300	100	50
4	Type 2	100	100
5	Type 3	500	125	75
6	Type 3	100	100
7	Type 4	125	125	100
8	Type 4	100	100
9	Type 5	125	125
10	Type 5	100	100

I would like it to look something like this.

RecordID	Type	Cost	Interest	MTM
1	Type 1	125	125
2	Type 1	100	100
		25	25		Difference
3	Type 2	300	100	50
4	Type 2	100	100
		200	0	50	Difference
5	Type 3	500	125	75
6	Type 3	100	100
		400	25	75	Difference
7	Type 4	125	125	100
8	Type 4	100	100
		25	25	100	Difference
9	Type 5	125	125
10	Type 5	100	100
		25	25	0	Difference

I appreciate the help with this.  Thank you!

[JosephSerpis]

Hi @cfine 

                 if you use a Multi-Row formula you should get the desired results. I've attached my workflow as well. 

[john_miller9 · Accepted solution]

If you need the output to look the same as you posted, this workflow should get you there.

[cfine]

This worked great.  One more question for you. What formula could I use in Multi Row to achieve the following:

Record ID	Type	Cost	Interest	MTM
1	Type 1	100	25	5
2	Type 1	100	25	10
3	Type 1	100	25	10
4	Type 1	100	25	10
5	Type 1	450	101	50
		250	51	35	Difference	Record ID 5 minus all others

Thank you!

[john_miller9]

I don't think just using a multi-row formula would get you there.  I would approach it like this to get RecordID 5 minus all others.