Average per product compared to total avarege

[#1]

I have a set of data like this (in orange)

The average per product is in blue and know I like to calculate the 'average per product' devided by the 'total avere' and put the numbers (those in green) in a bar chart.

Example Product A:

The average is 3.5 ((5+2) / 2 ) and compared to the total average i get 92 % (3.5 / 3.8 * 100)

Example Product C:

The average is 5 ((6+4) / 2 ) and compared to the total average i get 132 % (5 / 3.8 * 100)

How do I do that?

[sunny_talwar · Accepted solution]

This?

Expression 1: =Avg(Val)

Expression 2: =Avg(Val)/Avg(TOTAL Val)

[#3]

Thanks - I wasn't aware of the 'Total function':

=Avg(Val)/Avg(TOTAL Val)