How to subract 2 cells in a same column

[Rafiuddin_333]

Hello All, i have been working in Alteryx from past 2 weeks and trying to use it to automate my daily excel task. Coming to the point i have mentioned an example of table below

Product type	Product Category	Value
A	x	100
B	y	100

Can you guys let me know if there is any simple way to subtract value column only (Ex: 100-100) and add in another row below so that value would be zero.

Thank you very much

[binuacs · Accepted solution]

@Rafiuddin_333 One way of doing this

[Qiu · Accepted solution]

@Rafiuddin_333 
I dont if this is the best way. Anyway, Alteryx is not good at the cell manipulation. 

[Rafiuddin_333]

Thank you very much, i got the answer