6 Replies Latest reply on Apr 5, 2018 6:33 AM by Moira Reade

    Sum of sales in a month and compare to a moving average

    Moira Reade

      I'm uploading an example using superstore of how I'm currently displaying the Sum(sales) for subcategories during a month with a parameter to select how many to display.

       

      Now what I'd like to do is add a reference mark for the average sum(sales) for the same subcategories over the past 3 months.

       

      I cannot wrap my head around how to do it.  Can anyone help?

       

      Thanks!