Launch, grow, and unlock your career in data

March 1, 2016

Tableau Tip Tuesday: How to Display the Top N and Retain the % of Total

This week’s tip was sparked by a question that Jules Winceslaus of the Data School asked during a project we worked on last week for a customer. He created a bar chart that showed the percent of total, yet when he filtered the dimension, he wanted the original percent of total to remain. That is, the bars shouldn’t be recalculated based on the filter.

In the video and example below, you’ll learn how the rank function can be used to filter the results in the view without impacting the percent of total calculation.