I have attached a workbook and i have used rank for your solution hope it helps you.
And if this resolves your Problem please mark my answer as correct.
Top3.twbx 183.9 KB
can you please write the steps as I am new to tableau and to use this interface. I will be thankful to you
You can achieve this in so many ways,
Simplest one I've mentioned below
Drag your NAICS code in rows shelf and drag Gross Profit on label.
Now right click on NAICS field from dimension pane and create a set like this, go to the last tab and set top 3 by field gross profit.
Now drag the created set in filers shelf that's it.
More options to get the top N follow the below links
Hope this will help.
1 of 1 people found this helpful
Hi Sakshi Kaul
Once you will import this excel sheet in Tableau then Tableau will consider it as a measure. We need to convert it to dimension by right click and use convert to dimension.
Below you can see that it is in measure section and I'm converting it to dimension.
Like Below image.
Once you convert it to dimension then it will come in DImension section(Above) Automatically. See below image.
Now double click on NAICS 2012 Code. and then double click on Gross profit USD
then Drag NAICS 2012 Code from Dimension section into filter section and select TOP like below image.
select By Field--> Top 3
and click okay.
Please let me know if you need more help on this or if you need more explanation then please come on skype (suman4apr1)
Please mark correct and Helpful if it works for you.