Profit at a Glance: Top & Bottom N in Tableau
Updated: Jan 11
Photo from Unsplash
Great dashboards don’t just show data—they tell a story. This Tableau chart does exactly that by visually ranking the top and bottom N profit drivers in one clear view. When profit insights are easy to see, decisions become easier to make. Let’s look at how Tableau helps uncover profit leaders and underperformers immediately.
This guide will help you create “Profit at a Glance: Top & Bottom N in Tableau” in a single, clean view.
Step 1: Connect to Your Data- Load your dataset in Tableau. Create the dataset by joining the tables as outlined below. I’m using the Sample Superstore dataset from Kaggle and renamed it as RayS-Superstore. I am trying to create the top N & bottom N profitable categories/products in the same sheet.
Image by Author
Step 2: Define Rows and Columns- Place Product Name on the Rows shelf and Profit on the Columns shelf. Then, sort the products in descending order by profit to ensure that the highest-performing products are displayed at the top. The worksheet will appear as shown below.
Image by Author
Step 3: Create Parameter for Top & Bottom Products - Create the Top_N Parameter as below
1. In the Data pane, right-click → Create Parameter
2. Name: Top_N
3. Data Type: Integer
4. Current Value: 1
5. Allowable Values: Range (Ex: 1 to 100)
6. Click OK
7. Right-click the parameter → Show Parameter. Click the drop-down arrow next to the Top_N parameter on the worksheet and select “Type In". This configuration enables users to manually enter a value for the parameter, providing greater flexibility and control over the analysis.
8. Create a second parameter for the bottom values by naming it Bottom_N. You can either follow the same steps used to create Top_N, or duplicate the existing Top_N parameter by clicking its drop-down menu and selecting Duplicate. This will generate a parameter named Top_N (copy). Edit this parameter by selecting Edit from its drop-down menu, rename it to Bottom_N, and confirm. Finally, right-click the Bottom_N parameter and choose Show Parameter to display it on the worksheet. Click the drop- down arrow next to the Bottom_N parameter on the worksheet and select “Type In".
Image by Author
Image by Author
Step 4: Create a parameter for Top Products - Since we want the top Products, create the Top_Products set Parameter as below
1. Click on the drop-down of Product Name and select Create-> Set-> Give a name as Top_Products.
2. Click on the Top tab in the Create Set window ->By Field -> click on the 2nd drop down -> select Top_N parameter created above -> click OK.
Image by Author
Step 5: Create a parameter for Underperforming Products- Since we want the Bottom Products, create the Bottom_Products set Parameter as below
1. Click on the drop-down of Product Name and select Create-> Set-> Give a name as Bottom_Products.
2. Click on the Top tab in the Create Set window ->By Field -> click on the 2nd drop down -> select Bottom_N parameter created above -> click OK.
3. Alternative method to create the Bottom_Products is right-click on Top_Products -> click on Duplicate, a new set will be created-> right click on the newly created Top_Products(copy) and click on edit. Give a name as Bottom_Products-> click on top tab->By Field -> click on 2nd drop down -> select Bottom _N parameter created above ->click OK.
Step 6: Create Combined Set for Top & Bottom Products
1. Hold down the Ctrl key and select both Top_Products and Bottom_Products. Right-click the selected sets and choose Create Combined Set. Name the combined set Combined_Set, then drag it to the Filters shelf.
2. To enhance clarity, apply distinct colors to differentiate Top and Bottom products. Drag Top_Products and Bottom_Products to the Color shelf on the Marks card, then customize the colors as needed to distinguish between top-performing and bottom-performing products clearly.
Image by Author
Step 7: Rename the sheet- Give the name of the sheet as Top&Bottom_Products.
Step 8: Save the sheet- Save the above-created sheet as Save to Tableau Public for future reference.
The Big Reveal: A single Tableau chart that dynamically highlights the Top and Bottom N performers, making it easy to spot both profit leaders and underperformers at a glance.
At a Glance: This approach enables the easy identification of both top-performing and underperforming products in a single, dynamic Tableau view. By combining parameters and sets, the dashboard delivers flexible, user-driven insights with minimal complexity. The visualization helps decision-makers focus quickly on what’s working—and what needs attention. Dynamic Top and Bottom N analysis transforms raw profit data into actionable insight. With one chart, users gain immediate clarity into performance extremes without switching views.
Key Takeaways:
This visualization highlights the value of combining parameters and sets to enable dynamic, insight-driven dashboards. Let’s explore parameters and sets in more detail:
Parameter Overview:
A parameter is a dynamic input control that allows users to manually enter or select a value. This value can then be used in calculations, filters, or logic throughout the workbook.
Key Uses of Parameters
1. Allow users to control values dynamically (e.g., Top N = 5, 10, 20)
2. Create what-if analysis
3. Enable dynamic thresholds and targets
4. Switch between measures or dimensions
5. Control calculations, filters, and reference lines
Example Use Case:
User selects Top N products
Parameter value changes
Chart updates instantly
Note: Parameters do not filter data by themselves—they must be used in a calculated field.
Set Overview:
A set is a custom group of data members defined by conditions or manual selection. Sets categorize data into
IN / OUT groups.
Key Uses of Sets:
1. Highlight specific data points
2. Create Top N or Bottom N groups
5. Combine multiple conditions into one object
Example Use Case:
Set of Top 10 products by profit
Set updates automatically when data changes
Note: Sets dynamically respond to data changes but are not user-driven unless combined with a parameter.
Overview of Using Parameters and Sets Together:
The real power comes from combining parameters and sets.
Example:
Parameter: User chooses N
Set: Automatically selects Top N products
Result: Fully dynamic, user-driven analysis
This approach is commonly used in:
Top N / Bottom N analysis
Dynamic dashboards
Interactive storytelling
Key Learnings on Parameters and Set:
1. Use parameters when you need user input or flexibility.
2. Use sets when you need dynamic grouping or comparison.
3. Use both together to build powerful, interactive Tableau dashboards.
