Need the difference in the same column

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

Developer Tools

Accepted answers

aatalai

@Rafiuddin_333 take a look at the updated workflow

Need the difference in the same column v2.yxmd

All comments

aatalai

@Rafiuddin_333 see work flow attached it should do the trick

same column.PNG

Need the difference in the same column.yxmd

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

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"

Sample data.xlsx

aatalai

@Rafiuddin_333 take a look at the updated workflow

Need the difference in the same column v2.yxmd

Rafiuddin_333

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703