Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have brands and products in the dimension of the table. I want to take the average of their score in the pivot table:
Brand Name | Product Name | Score | avg |
---|---|---|---|
Brand 1 | Product 1 | 100 | 250 |
Brand 1 | Product 2 | 200 | 250 |
Brand 1 | Product 3 | 300 | 250 |
Brand 1 | Product 4 | 400 | 250 |
I want to make the table as shown above when the dimensions are all expanded. When I collapse the product name field, it works well but when I expand it, it will show the exact value of the score on the avg field.Can you help me doing this?
Thank you
AVG({1}TOTAL <[Brand Name]> Score)
avg(TOTAL score)
Sum(Score) / count(Product Name)
would work too in this example.
It depends on exactly what you want. The difficulty comes if some of the values are zero and they need to be counted as well.
R
Thanks for help. I solved it. The problem occured because of the calculated dimension. After copying calculated dimension to the set analysis. the avg function will work.