6 Replies Latest reply on Aug 8, 2018 10:43 AM by Josh Williams

    How to display current sales data while having option to view prev data

    Josh Williams

      Hi, I am currently using the formula:

       

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

       

      To display the most recent sales data. In addition to displaying the recent data, I also want the option where I can also get past sales information through any means such as filters. Is this achievable? Thank you