SumIf Subtraction of Row Items

[BrianDeg]

Hello! I have the following data with six rows and a header and I am trying to within Alteryx turn it into the second data table with 9 rows + a header. I would like a solution to the following that could work with six rows or six million rows. 

For each Year, I want to subtract the Value in Second from the Value in First. 

For example, for 2015, FIrst has a value of 10 and Second has a value of 5. I want to subtract 5 from 10  (i.e. 10-5 = 5) and put that in a new row with a Year as 2015, Name as Third, and Value as 5. 

Input Data:

Year	Name	Value
2015	First	10
2016	First	20
2017	First	30
2015	Second	5
2016	Second	5
2017	Second	5

Desired Output:

Year	Name	Value
2015	First	10
2016	First	20
2017	First	30
2015	Second	5
2016	Second	5
2017	Second	5
2015	Third	5
2016	Third	15
2017	Third	25

Please let me know if you have further questions, and thanks in advance for your help!

[Hugo · Accepted solution]

Hi Andy,

Take a look at the attached - it should work regardless of the number of years, but not necessarily if there are more than 2 values you need to subtract, though you could modify it to suit your needs.

Regards,

Hugo