Subtract two columns based on criteria

Question

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

Adjustments.yxmd

flying008 · Answer

Hi, @dsevilimedu

Please see that below:

******

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

niteshsharma677 · Answer

Hi @dsevilimedu

I have attached a possible solution.

Regards,

Nitesh

Adjustments.yxmd

apathetichell · Answer

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.