Hi,
I manipulated my data using Alteryx. Now, the structure is as follows:
Store/Chain | Item A | Item B |
M. A. | 5 | 3 |
A. M. | 10 | 5 |
A. B. | 8 | 7 |
J. L. | 2 | 9 |
I want to have a look at the store/chain M.A. for item A.
To do this, I'd like to get the following structure:
Market size A | =10+5+8+2=25 |
Interesting store | M. A. |
Sales A | 5 |
M. A. abs share A | =5/25 |
M. A. rel share A | =5/(10/25) |
Top 1 comp. | A. M. |
Sales A | 10 |
Top 2 comp. | A. B. |
Sales A | 8 |
The equations are just an illustration. I don't need the single numbers. I just need the result in the cell.
Do you have any idea how to achieve this?
Thank you very much.
P.S.: I am quite new to Alteryx.
Solved! Go to Solution.
Hey @gumpi
I have mocked up a workflow that I thing meets your requirements.
Workflow
Output
Let me know if that helps
Works perfectly. Thank you for your effort and have a nice week!
You're welcome @gumpi , have a nice week too