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

    dynamic averages for a period

    Alex Martino

      Hello.

       

      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".