Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (55.6k points)

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

1 Answer

0 votes
by (119k points)

 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]


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.

Related questions

0 votes
1 answer
0 votes
1 answer
asked Oct 16, 2020 in BI by Sudhir_1997 (55.6k points)
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

29.3k questions

30.6k answers


104k users

Browse Categories