In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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