Need the difference in the same column

[Rafiuddin_333]

Hello All,

I have a data set and i need the difference in this format (Attached table below)

Desired output:

Products	Cost (x)	Items	Cost(Y)	Variance (X)-(Y)
A	100	X	500	-250
B	150

I need the output in the same format as attached above and when I try to do it in Alteryx using summarize and union tool I am getting the output 

Output I am getting now:

Products	Cost (x)	Items	Cost(Y)	Variance (X)-(Y)
A	100	X	500
B	150
Total	250	Total	500	-250

Can you please let me know if there any way I can move the variance to Specific Item it relates to (X in the above example)

Thanks a lot for your effort and time.

Regards,

Rafi

[aatalai]

@Rafiuddin_333 see work flow attached it should do the trick

[Rafiuddin_333]

Hello @aatalai , the workflow u have shared with me is exactly the output I am getting, I need the variance in the same column as cost and not as total

[Mathias_Nielsen]

Hi @Rafiuddin_333 , can you provide an example of the desired output? I think that would be easier :)

[Rafiuddin_333]

Hello @Mathias_Nielsen  this is my desired output

Desired output:

Products	Cost (x)	Items	Cost(Y)	Variance (X)-(Y)
A	100	X	500	-250
B	150

[Mathias_Nielsen]

HI @Rafiuddin_333,

I misread your first post. Can you provide some sample data? It is usually easier to come up with a solution when you have as-is and to-be examples :D

[Rafiuddin_333]

Hello @Mathias_Nielsen 

Please find the attached sample data. If you can see the file, what I need is the column "F" in the same line as "Item"

[aatalai · Accepted solution]

@Rafiuddin_333 take a look at the updated workflow

[Rafiuddin_333]

Thanks alot @aatalai, its working fine and I am getting the result