This content has been marked as final. Show 3 replies
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!
Attached is a packaged workbook.