Subtract sum of multiple rows from another row based on two columns

[Giaaa1220]

Hi, please see my attached image for an example of my data structure.

I have four portfolios in my data structure for each month: total, sub1, sub2, sub3.

I want to add another row called others( calculated by total- sum(sub1,sub2,sub3)) for each month

Not sure how to do this using Alteryx. Thanks!

[Simha · Accepted solution]

Hi, Here's a solution to your problem. Please don't forget to accept the solution if you like 🙂

Simha

[JosephSerpis]

Hi @Giaaa1220 I mocked up a workflow let me know what you think?