Restructure Data Record

[gumpi]

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.

[AngelosPachis · Accepted solution]

Hey @gumpi 

I have mocked up a workflow that I thing meets your requirements.

Workflow

Output

Let me know if that helps

[gumpi]

Works perfectly. Thank you for your effort and have a nice week!

[AngelosPachis]

You're welcome @gumpi , have a nice week too