• Bernard

Tableau Tips: Top/Bottom N members (use of table calculation- Rank)

Updated: Sep 3


In the previous article of this series, I showed you how to populate the Top/Bottom 10 profitable customers using sets. In this article, I will show you another technique to tackle the same challenge, but now using table calculation rank.

I will be using Superstores data set pre-packaged with Tableau app

Once you've connected to the data set above.

Right click any where under dimension or measure area and select Create >> Calculated field.

Rank customers in descending order ( by Profit)

On the calculation editor fill it as shown below.

This formula helps us rank customers in descending order by Profit.

Note: Above calculation does not specified how our ranking is being computed, to set the computation to rank profit a long the Customer Name, select Default Table Calculation above and chose compute using Customer Name.

Rank customers in ascending order ( by Profit)

Repeat the above process to rank Profit in ascending order along Customer Name.

Using the two calculated fields above, I'll categorize them into Top 10 and Bottom 10 profitable customers using the formula below.

Now that I've categorized my computation above, lets build our chart.

  • Drag Customer Name from the dimension field to the Row shelf.

  • Drag profit from the measure field to the Column shelf.

  • Sort the chart in descending order by clicking on the sort icon on the tool bar.

  • Drag the calculated field Top/Bottom 10 profitable customers to the Filters and choose 'Top 10 profitable customers' and 'Bottom 10 profitable customers'

  • Drag Top/Bottom 10 profitable customers again to the color pill and customize your colors. (optional)

See the resulting chart,.

Comparing the resulting chart above from our previous example, you can concur with me that the results are the same. I hope one of the technique will be helpful to you.

See you in the next article.

Thanks for reading.

#Learningtips