1 Reply Latest reply on Aug 29, 2018 3:56 PM by Esther Aller

    12 Month average outside of the filter

    Shawn Jones

      Hey all,

       

       

      I'm trying to create a 12 month moving average that isn't impacted by the filtered date range in the view. For instance in the attached workbook, the moving average value is the same as the monthly value. If you change the filter dates then the moving average changes also. I know I can calculate it in an excel file but I need this calculation for items where I'm tied into databases that I can't add fields to. Is there a way to do this with a calculation?

       

      Any help is appreciated.

       

      -Shawn