0 Replies Latest reply on Sep 25, 2018 11:09 PM by Alex Martino

    dynamic averages for a period

    Alex Martino



      Is there a way to create dynamic averages based on the dimension that I use?


      For example:

      Category: Style

      Category 2#: Size

      Category 3: Color


      The data has a number of rows for each date (essentially a row is a sales transaction)


      How can I create an average formula that will compute daily average (by whatever period that is filtered) that will update as I move dimensions. It seems strange that I have to create a calculation for each "level".