3 Replies Latest reply on Nov 20, 2018 9:37 AM by Pascal Bibeau-Palomo

    Show value for latest date as well as moving average for last 30days together.


      Hi All,


      I'm stuck with a calculation which seems to be a realistic scenario but not working.

      In a table , I want to show value for latest date and in next column , want to show moving average of last 30 days for the same measure.


      As soon as I put filter to show value for latest date, the moving average does not work as now it has only the last value available.

      Any pointers in this scenario will be much appreciated.