It's hard to say what is going "wild" in your workbook from a distance.
Find my approach as reference below and stored in attached workbook version 9.3 based on "how to..."
Nested Sort.twbx 49.1 KB
Thanks for getting back to me on this. It seems that when I did not use the combined field, this problem occurs but with the combined field that I created (Action Name + Date), the rankings are correct. Any idea why this is so?