Pivot Table Average problem

[#1]

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

[MK_QSL]

Try

Avg({1}TOTAL Score)

[VishalWaghole]

Hi,

Please find attached file, it will help you.

- Regards,

Vishal Waghole

[#4]

Brand Name	Product Name	Score	Avg
Brand 1	Prod 1.1	100	150
Brand 1	Prod 1.2	200	150
Brand 2	Prod 2.1	300	400
Brand 2	Prod 2.2	500	400

I forgot to mention that there are other brands in the table. Therefore I need to calculate all the brands' average individually.

[its_anandrjs]

Write in new expression for pivot table

Avg({1} ALL Score)

[#6]

Hi Anand. It calculates the avg of the score of all brands but I need to take the average of only the corresponding brand.

[MK_QSL]

Try

AVG({1}TOTAL <[Brand Name]> Score)

or

AVG({TOTAL <[Brand Name]> Score)

[its_anandrjs]

Ok then try like

Avg(ALL <[Brand Name]> Score)

[richard_pearce6]

Try  avg(aggr(avg(Score),[Brand Name]))

Richard

qlikcentral | Understand / Create / Inform

[#10]

Hi thanks for help. These expressions work but only when the product field is collapsed. When I expand the dimensions the avg(score) equals to the sum(score).