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?