Your sample data may not be correct. Prosecution is not the max date for Case #2. That may be a typo.
I attached a workbook that filters data based on the "last() = 0" criteria.
The table calc in the filter had to be done using the advance function with level of date and restart every case #.
I'm not sure what the problem is with your second problem. If you can post some additional data with the expected result, it would be easier to help with.
community 149738.twbx 7.5 KB
Love it...I needed this exact solution and it worked beautifully. I also like the fact that I can use quick filters and the status will dynamically change with the filters.