I think I was on a mission looking for examples where dense_rank worked in criteria ( like you ), and found some stuff about dense_rank and keep and then distinct and how it's used. Then this article came up https://netsuite.custhelp.com/app/answers/detail/a_id/30128/