8 Replies Latest reply on Mar 11, 2013 12:50 PM by Armando Ramirez

    Calculate AVG of an aggregation at a Higher level

    Armando Ramirez

      I have # of Items on sale, at the Region-Store-ProductCategory level as shown in the workbook attached.

      Then I would like to calculate the AVG of the # of Items at the Region-ProductCategory level and display those results as shown below:

      AVG.bmp

       

      Any thoughts??

       

      Thanks!