3 Replies Latest reply on Nov 13, 2018 9:09 AM by Don Wise

    Show values in hierarchy based on most recent date

    Alex  Gunnerson

      Hi all,

       

      In the example below, I would like to show one status for each environment. In my specific case, whenever the status of a problem is changed, it is added to the database as a new record which is why there is two different status' for Problem #1 Environment 7 in the picture below.  I want to show only the most recent status for each environment based on the date. I have tried creating a calculated fields and using rank to solve this

      but have not had any luck. If anyone has some advice on how to solve this problem I would greatly appreciate it!

      Capture.PNG

       

      Attached is a packaged workbook.

       

      Thanks,

      Alex