I have 3 columns with data customer, country and Sales. Also I added count(county) columns, because I need to build second chart.
I should determinte positions of counties based on count(county), for example if CN is 5589 this mean that CN is main Country, BE is 277, so BE is 2nd CoO.
How can I do this?
Country
Count
BE
277
CA
30
CN
5589
DE
3
customer
Main Country
2nd CoO
3th CoO
4th CoO
5th CoO
6th CoO
7th CoO
Sales
7307151090
PL
MX
CN
UA
BE
CA
GB
15069
Press LIKE if the given solution helps to solve the problem. If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").