Ranking with different granularity

Hi @AntrikshSharma,
Thank you for this formula!
It solved the problem.
I have actually looked at one of your previous posts - Understanding RANKX with additional fields
however, could not figure out who to make it work. :slight_smile: