How to Create Parameter for Top N Items?

woman pointing black pen on white paper with graph


In a business scenario, measuring performance of various products is an important and regular activity. How to find the Top 10 Products? Or how to use a parameter to find the Top N Items for any particular category? It is a key metric to identify how a business is performing. The leadership can assess and plan accordingly to make key decisions based on what the analytics show.

Read more: How to Calculate the First Monday of the Month? »

Tableau Parameters to Find Top N Items
Tableau Parameters to Find Top N Items

Steps to Create Tableau Parameter for Top N

Let’s say we have a table with the dimension Product Name and the corresponding total Sales for each Product. We want to see the Top N Products by Sales using a Parameter. We want to be able to interact with the parameter and decide the value of N at our convenience. How can we achieve this in Tableau? How can we create such a Tableau Parameter that can allow us to interact with it and provide a flexible value of Top N items?

Tableau Parameters to Find Top N Items
Tableau Parameter to find Top N Items

As we see here, first Drag the dimension which we want to find the Top N for and place it in Filters. Then go to the ’Top’ tab, and under ’By field’, select ‘Create a New Parameter’. Give the Parameter a name. Mention how many Top items you want to view, i.e. Top 5 or Top 10 etc. On the left pane in Parameters, right click on the Parameter and choose ’Show Parameter’. Now you can interactively choose using a Parameter how many Top N items you want in your analysis.

Keep reading: Tableau Desktop Specialist Certification Questions »

Loading RSS Feed

Why Create a Tableau Top N Parameter

A Tableau Parameter is very helpful in adding interactivity to a report or dashboard. It helps to analyze the data with the flexibility to find any number of Top N items. Example the Top 5 Products by Sales, or the Top 10 Products by Profit, or the Top 10 States by highest Products sold, or the Top 2 students with highest average marks who qualified for a scholarship. Using a Tableau Parameter, thus we can add powerful features to our Tableau analysis and achieve greater insights from our data.

Keep on Reading: Tableau Data Analyst Certification Questions »

Get our Most Popular Downloads

Download the most popular scenario-based Tableau Workbooks in .twbx format. Used by thousands of Tableau developers and job aspirants every day to improve and fine-tune their CV and Tableau Public profile. Join the largest Tableau Experts Social Group.

Tableau Banking and Financial Dataset Analysis Download
Banking & Financial Dataset Analysis

Financial Domain Tableau Dataset and Analysis. The most important domain in today’s industry. Analyze Key Performance Indicators. Discover Risky and Fraudulent Outliers. Download the Tableau Packaged (.twbx) Workbook. Includes a complete Financial dataset analysis. Enhance your Data Analytics experience with our skilled analysis.

Tableau Healthcare and Hospital Dataset Analysis Download
Healthcare & Hospital Dataset Analysis

Hospital and Healthcare Domain Tableau Dataset and Analysis. A key field of study with millions of lives at stake. The most sensitive industry today. Download the Tableau Packaged (.twbx) Workbook. Understand how healthcare datasets work. Includes a complete Healthcare dataset with analytical charts. Explore Tableau interactive features with this download.

Tableau Insurance Dataset Analysis Download
Insurance Dataset Analysis

Insurance Domain Tableau Dataset and Analysis. Important domain specific metrics and data. Learn how to visualize important metrics. Show outliers and insightful data points. Download the Tableau Packaged (.twbx) Workbook. Includes comprehensive analysis of Insurance data of a large sample population. Uses industry standard analytical practices.

Tableau Practice Test

The best Tableau practice exams built. Period. Explore definitive practical problems created by brilliant Tableau experts.

Get in Touch

Contact Us
Write for Us

Published by Rahul Bhattacharya

Rahul is a journalist with expertise in researching a variety of topics and writing engaging contents. He is also a data analyst and an expert in visualizing business scenarios using data science. Rahul is skilled in a number of programming languages and data analysis tools. When he is not busy writing, Rahul can be found somewhere in the Appalachian trails or in an ethnic restaurant in Chicago.

One thought on “How to Create Parameter for Top N Items?

Leave a Reply