I'm trying to add a column to a table with the value of one column (Value) divided by the average of the values from the same Name and Label as you can see in the picture. In another words, I would like to add a column with x divided by the average of y, where "y" are the values from the same name and label of the entry.
the output I want is:
2.555,45/2.311 = 1.1
1.870,83/ 2.311 = 0.796
The problem is to find the average of this subset, instead of the average of all values of the table. I'm sure it's really simple, but I started with Qlikview this week, so I'm having some simple problems...
Thanks a lot!