Subtract two columns based on criteria

[dsevilimedu]

Hi,

I am trying to find a way to calculate difference between two columns based on 2 criterias - 1) Product 2) Month. The output I am looking for alteryx to do is add a column, and subtract values. For example: The difference between price 1 and price 2 is 100 for period 1, for product 123456, -900 for blanks, 400 for period 2, 500 for period 3. My dataset, unfortunately, is arranged this way. Perhaps, something to do with Transpose, Multi-Row and Cross Tab? there might be a better solution? Thanks! 

Output

[apathetichell]

summarize tool. group by category, product, month. sum price 1, sum price 2. formual tool for new column delta sum price 1- sum price 2.

[niteshsharma677]

Hi @dsevilimedu 

I have attached a possible solution.

Regards,

Nitesh

[flying008]

Hi, @dsevilimedu 

Please see that below:

******

If it can help you , please mark it as a solution and give a like for more share.