How to show top 5 and bottom 5 in tableau?

Question

Can anyone tell me how to show top 5 and bottom 5 in tableau?

Answer 1

 Here are the steps to show the top 5 and bottom 5 in tableau:

1. Create a calculated field with the calculation as follows:

RANK( SUM( [Sales] ), 'desc' ) <= [N Parameter]

OR

RANK( SUM( [Sales] ), 'asc' ) <= [N Parameter]

The above calculation returns a TRUE only if SUM( [Sales] ) is the highest N ranking sub-categories for either top N or bottom N .

2. Drag the newly created field to the Filters shelf. Click OK to close the Filter dialog.

3. Right-click the newly created field on the Filters shelf. Select Compute using > Pane (Down).

4. In the Filter dialog, check True. Click OK.

If you want to learn Tableau, check out this Tableau Training Course by Intellipaat.

Answer 2

In tableau there are many ways through which we can find the top 5 and bottom 5 for a data. One of those methods is using the parameters. For this you need to open the worksheet you are working on, under the data pane, select Create Parameter option and then after that in the create parameter dialog box, in the name box use the variable name and for the data type use integer and set the current value to 5, and for allowable values select ranges. Under ranges, you can select minimum and maximum values for N records you want.