set analysis to calculate a double weighted average
Hello I have to calculate a weighted average to appear in the Total of a table.
The difficulty lies in the fact that it is the weighted average of a weighted average and I have to calculate it directly in a table through the set analysis.
Let me explain better, in the cells of the row must appear the value of the first weighted average, but in the total must appear the weighted average of the average calculated in the individual cells.
I was thinking of making a nested sum but I can not get over it. I enclose a sample table of the calculation that I have to do.
In practice I have a Dimension for each row of which I calculate the hourly revenue of the hours through heavy average of the records present. and this value goes into the cells of the respective rows. For each row for I have another column, always hours but with other meaning that I need in turn to calculate the total according to the weighted average of the calculated values precedents.
I enclose an example image. of which the value I expect is € 41.80 Thanks in advance
