21 Replies Latest reply: May 12, 2017 2:34 PM by Sunny Talwar RSS

    Pick only  value for latest date

    Akpofure Enughwure

      Good day one

       

      I have a set of data I need to pick only the latest data

       

      Location01/01/201702/01/201703/01/2017
      Area 1150100120
      Area 21004060
      Area 370100150

       

      I used the crosstable function to resolve my data

      Something like this

       

      At the backend

       

      Fox:

      CrossTable (Date, Value, 1)

       

      LOAD [Location],

          [42736],

          [42737],

          [42738]

       

      from DAILY Sales.xlsx]

      (ooxml, embedded labels, table is Sample);

       

       

       

      FinalTable:

      Load [Location],

        Date(Num#(Date)) as Date,
      Month(Num#(Date)) as Month,
      'Q' & Ceil(Month(Num#(Date))/3) as Quarter,
      MonthName(Num#(Date)) as MonthYear,
      Year(Num#(Date)) as Year,
      Day(Num#(Date)) as Day,
      Value

      Resident Fox;

       

      Drop Table Fox;

       

       

      All I need is how I can only display value based on latest date