7 Replies Latest reply on May 22, 2019 6:03 AM by Zhouyi Zhang

    Average of averages of averages.

    othon tzobras

      Hello all,

       

      I have the following hierarchy of groups: stores, dealers, brands, market. Each dealer has a number of stores. Each brand has a number of dealers. Each market has a number of brands.

       

      I have one score for each store. I need to calculate a score according to the rule:

       

      The score for each dealer is the average of the scores of the dealer's stores.

       

      The score for the brand is the the average of the dealers' scores

       

      The score of the market is the average of the brands' scores.

       

      Is there a way to calculate all these scores in a workbook?

       

      PS I cannot attach a workbook cause the material is confidential but, if needed, I can create a fake dataset.