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 ...
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
Super User
Super UserDIY. Read this article - Vendor Analysis In Inventory Management Dashboards (enterprisedna.co)