2 Replies Latest reply: Nov 9, 2012 5:05 AM by Andrew11 RSS

    How to return the latest status per Project based on date

      Hi

       

      I have a list of Projects with the status of each project at a certain point in time. What I would like to do is create a straight table that shows the latest status per project, ie something like:

       

       

      LatestStatus.JPG

       

       

      Thanks for you help

       

       

      Sample data:

       

      Load

      *

      INLINE [

          ProjectID, StatusDate, Status

          P1, 2012/01/01, Active

          P1, 2012/01/20, on Hold

          P1, 2012/02/15, Discontinued

          P2, 2012/01/05, Active

          P2, 2012/01/07, on Hold

          P3, 2012/01/02, Active

          P3, 2012/01/09, Discontinued

      ]
      ;