KNOWLEDGE BASE

Displaying Top Percent Instead of Top N


Published: 17 May 2016
Last Modified Date: 04 Jul 2017

Question

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

Environment

Tableau Desktop

Answer

The following instructions can be reviewed in the workbook attached below.
  1. Create a 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?