2 Replies Latest reply: Nov 18, 2015 3:22 AM by KENNETH ANDERSEN RSS

    Average per product compared to total avarege

    KENNETH ANDERSEN

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

      Udklip.JPG

       

      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?