Hi @ljuturi1 ,
I created some data:
Here are the steps you can follow：
1. Create calculated table.
Table 2 =
2. Relationship to join two tables.
3. Select [Customer] – Column tools – Sort by column – [rank] for the new table.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly