Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

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
‎07-13-2023 07:55 AM

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

 

 

 

Preview file
13 KB
Labels:
Reply
0 Likes
2 REPLIES 2
rohityaman
8 - Asteroid
‎07-13-2023 10:07 AM

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

 

DeltaCalculation_for_Demand_and_Supply.jpg

DeltaCalculation_for_Demand_and_Supply.yxzp
Reply
0 Likes
MikeFrancis1959
8 - Asteroid
‎07-13-2023 10:58 AM

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

Thanks,

Mike

Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All