We have 12 main markets that we sell - I'm looking for a way that I can display the top 3 clients fo reach market + Others dynamically.
For example, if client 1 is a top 3 client for Japan, their sales will show in Japan as "Client 1" but if they are not top 3 in China the client will be bucketed into "Others"
Any ideas on how this might be achievable?
![[1500] Sales with Sales Month.png [1500] Sales with Sales Month.png](https://us.v-cdn.net/6032830/uploads/lithium_attachments/3722iB8E58DDA7D470A75.jpg)