Forum Discussion
Solved
Ranking based on multiple columns
Hi all,
I am trying to get ranking based on two criteria : Sales Quarter and Customer Name. Can you advise what is the best solution?
Sample:
https://drive.google.com/file/d/1d6V4mKM4vzmeFqHDCvtZomLyxl6t4sPR/view?usp=share_link
| Sales Quarter | Customer | Sales Amount | Rank |
| 22-Q4 | C | 70 | 3 |
| 22-Q4 | B | 90 | 2 |
| 22-Q4 | A | 100 | 1 |
| 23-Q1 | C | 80 | 3 |
| 23-Q1 | B | 150 | 2 |
| 23-Q1 | A | 300 | 1 |
3 Replies
Thanks! It works perfectly
You are most Welcome!
