7 Replies Latest reply: Aug 14, 2017 3:34 AM by Onno van Knotsenburg RSS

    Rolling Average in Column Chart

    conor cliffe

      Hello,

       

      I am trying to calculate a rolling average line where the 'average' for a month = (current month + previous month) / 2.

       

      This is depicted by the 'average' row in the screenshot below.

       

      For all intents and purposes, we will say that my expression is Sum(Sales).

       

      Thank you.

       

      Average.PNG