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

    How to return the latest status per Project based on date



      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:






      Thanks for you help



      Sample data:




      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