3 Replies Latest reply on Aug 8, 2018 6:55 AM by John Lee

    How to display present value and also have option to view past data

    John Lee

      Hi, currently I have past data from 2017 and also the most recent data that is up to date. To display the most recent sales data, I used the calculation:

       

      IF {MAX([Date])}=[Date]THEN [Sales] END

       

      This calculation shows only the most recent data. In addition to showing most recent data, I want to be able to select and view past sales data that automatically updates as time goes by. So for example, when september comes around, I can view august 2018 past data.

       

      Is there a way to achieve this? Thank you