Calculation InDEX

[AntonioBiancofiore]

Hi All, I've tried to create a Alteryx for solve my work. 

Started with the data and create an Index

in the data.xls there are tree sheet, 1) Source 2) Calculation 3) Output.

thanks in advance that can solve me the problem

[grossal · Accepted solution]

Hi @AntonioBiancofiore,

here is a quick way to create your index:

Output:

What happens:

- I create the Total Sum per product and year using the Summarize Tool

- Joining everything back together

- Calculating the Index (Formula)

- Selecting only the needed columns

Workflow attached. Let me know if this solved your problem.

Best

Alex