2 Replies Latest reply on Jul 31, 2018 7:25 AM by Willy Serra

    Compare previous week vs current week balance

    Willy Serra

      I need to compare data from previous week vs current week but only from most recent time in that day. Here is the table:

       

      Report DateSales Balance
      7/22/18 1:36 AM$        160.00
      7/23/18 1:33 AM$        168.00
      7/23/18 11:04 AM$        169.00
      7/23/18 5:04 PM$        170.00
      7/24/18 1:33 AM$        174.00
      7/24/18 11:04 AM$        175.00
      7/25/18 1:33 AM$        177.00
      7/25/18 11:05 AM$        180.00
      7/26/18 1:36 AM$        199.00
      7/26/18 11:08 AM$        200.00
      7/27/18 1:34 AM$        210.00
      7/27/18 11:05 AM$        229.00
      7/28/18 11:59 AM$        233.00
      7/29/18 1:34 AM$        235.00
      7/30/18 2:39 AM$        240.00
      7/30/18 3:55 PM$        250.00

       

      Output should be as follows:

              

      MeasureCurrent WeekPrevious WeekNet Change
      Sales Balance$        250.00 $       170.00 $      80.00

       

       

      Thanks