Displaying Top Percent Instead of Top N

Published: 17 May 2016
Last Modified Date: 15 May 2018


How to display the Top percentage of a field instead of the Top N.


Tableau Desktop


The following instructions can be reviewed in the workbook attached below.
  1. Select Analysis > Create Calculated Field with a formula similar to the following: 

    INDEX() <= INT(SIZE()/5)

  2. Place the calculated field onto the Filters shelf and select True.
Note: Dividing by 5 will give the top 20 percent. This number can be adjusted to achieve the desired percentage. 
Did this article resolve the issue?