Can I create a workflow in Alteryx to mimic this Excel file showing delta's

Question

I have an Excel file that shows the purchase orders by week vs the sales orders and my manager asked that I create in the format attached in Alteryx. I have 2 files that I will use, one for purchase orders and one for sales orders. The part of the workflow I am not sure about is that the PO qty is on row 1, the SO on line 2 and the delta between the two is on row 3 and this is where I am not sure how to start the formula. I thought about multi row formula but I dont this this will produce the results I want, can someone point me in the right direction?

Thanks,

Mike

po so delta.xlsx

FrederikE · Accepted Answer

Hey @MikeFrancis1959,

I guess SO and PO Data is provided and you want to calculate the Delta everywhere?

You could do the following:

Muli-Row is not so great because you would need to combine a Multirow and Multicolumn approach.