Forum Discussion
Calculate the second and third highest countries by Sales values
Sample data attached We need to know the top ,top 2nd country and top 3rd country with highest sum of sales. Need to create 3 measures accordingly. Country Sales Year Month
India ...
Ashish_Mathur
Super User
Super UserHi,
This can be done with a single measure. Share data of more than 3 countries. Also, please clarify what the result should be if there is a tie in sales.
You may add for one dummy country if you want. In my case, tie situation will not be there.
So you may ignore that
- Ashish_Mathur
DIY. Read this article - Vendor Analysis In Inventory Management Dashboards (enterprisedna.co)