5 Replies Latest reply on Jun 24, 2018 9:29 PM by Haan Haan

    Show data for max date in dataset with comparisons to previous dates

    Doll Joll

      Hello,

       

      I have a dataset that looks like this

       

      DateSales
      7/28/16$100
      7/29/16$125
      7/30/16$85
      7/31/16$70

       

      What I want to show is data for max date in data set i.e. 7/31/16 with comparisons to previous dates

       

      Date                    Sales          Sales Difference vs Prev Day

      7/31/2016            $70               -$15

       

      The date needs to automatically advance every day to the most recent date.

       

      How do I achieve this ?