4 Replies Latest reply on Dec 5, 2016 4:55 PM by Shinichiro Murakami

    Moving average calculation

    Naresh Karumanchi

      Data source: sample superstore(attached).

       

      What is the profitable moving average in November 2013, including four months prior and four months after?

       

      I tried creating a line chart with month(Order date) date value in Columns and sum(profit) moving average table calculation, but i am getting 9833 as the value for November 2013. looks like the correct answer is $8441. i am not sure what i am doing wrong here?