Unfortunately, this isn't working.The problem is that RankX() calculates on Customer No level instead of Customer Name. How to not consider CustomerNo? Here is the sample file.
https://drive.google.com/file/d/1gwFVz2ga4w0aOi0KZsthBiQmocZ5QxLp/view?usp=drive_link