I am having issues with a formula and I might be going about it the rong way. I want to add a column to a saved search that shoes the 1 sublist item from a record based on a criteria that I define. Example: A saved search on Cases that gives me the latest message: I have tried the following formula: case when ((dense_rank () over (order by {messages.message} DESC)) =1) then {messages.message} else NULL end I noticed that this ranks the results in the saved search and not the messages sublist of cases. Does anyone have a solution/can tell me what I am missing?

Not sure about what else is going on in the saved search, but answer ID 18727 gives a solution for returning the most recent message from a case.

@Gregory Jones Thank you for the info. I gave it a try but it only brings in 1 result. The latest one. I want to have a list (based on specific criteria) and for each result, have the last associated message show. I will dig some more through different forums and update this thread if I find anything. Thanks again.