Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to create a workflow using this type of data

MikeFrancis1959
8 - Asteroid

I have an Excel report that shows forecast for a PN and then the planned Supply and the Delta is just a simple calculation. I want to create this in Alteryx but here is my question. I usually have data running horizontally and then do a calculation but this file is done vertically with every 3rd row having the calculation so I am not sure how to structure this. Does anyone have an example to share to see how this may be done. This may be easy but I am not sure where to start at.

Mike

 

 

 

2 REPLIES 2
rohityaman
8 - Asteroid

Here is one solution. You can make slight adjustments to suit your needs better.

 

DeltaCalculation_for_Demand_and_Supply.jpg

MikeFrancis1959
8 - Asteroid

Thank you, I will play with data so I can understand how you did this but it appears that this will work.

Thanks,

Mike

Labels
Top Solution Authors