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

    Rolling Average in Column Chart

    conor cliffe



      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.