I want to create a saved search which will return the latest change in a project record pulling from the System Notes. I want to show the date, field that was changed, new and old value. However the challenge lies when I tried to set all the system notes field to maximum and the Project Name as group. The results seemed to be mismatching since what Netsuite does is it maximizes the Date (latest), Field (alphabetical), New and Old Value (alphabetical). Does anyone know any workaround on this? Like a formula perhaps? Any answer is appreciated. Thank you!

Think you need to use RANK, DENSE or both for this one.