How to Filter Top 10 in Tableau

Focusing on your top-performing products, regions, or marketing campaigns is one of the fastest ways to understand what's driving your business. In Tableau, filtering your data to show only the Top 10 (or Top N) is a fundamental skill for creating clean, impactful visualizations. This article will walk you through four different methods, from a simple drag-and-drop filter to more advanced techniques that give you greater flexibility and control.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Bother Filtering for the Top 10?

Dashboards crammed with hundreds of rows of data can be overwhelming and often hide the most important insights. Imagine trying to analyze a bar chart with 500 different products along the axis. It’s impossible to read and even harder to act on. By filtering down to the "Top N" - whether it's the Top 5, 10, or 20 - you achieve several key goals:

• Clarity and Focus: It immediately draws attention to the elements that have the most significant impact on your business, like the products generating the most revenue or the landing pages with the highest conversion rates.
• Improved Performance: Asking Tableau to render thousands of data points can slow down your dashboards. Showing a smaller, more relevant subset of data can improve loading times and make your reports feel snappier for yourself and your stakeholders.
• Actionable Insights: When you can clearly see your winners, you can make better decisions. You can double down on high-performing ad campaigns, promote your best-selling items, or learn from your most successful sales reps to train the rest of the team.

Method 1: The Quick and Easy Dimension Filter

This is the most direct way to get a Top 10 list in Tableau and is perfect for quick analysis or static reports where the number "10" won't need to change.

Let's use a common example: finding the Top 10 best-selling products. For this, we'll use the Sample - Superstore data source that comes with Tableau.

Step-by-step Instructions:

1. Build a basic view. Drag the Product Name dimension to the Rows shelf and the Sales measure to the Columns shelf. This will create a bar chart showing the sales for every product. To make it easier to see, sort the chart in descending order by clicking the sort icon in the toolbar.
2. Drag the dimension to the Filters shelf. Find Product Name in the Data pane again and this time, drag it over to the Filters shelf. A dialog box will pop up.
3. Navigate to the 'Top' tab. In the Filter dialog box, you'll see several tabs like General, Wildcard, Condition, and Top. Click on Top.
4. Define the Top N rule. Select the radio button for "By field". The default settings are often what you need, but let's confirm them:
5. Click 'Apply' or 'OK'. Your visualization will immediately update to show only the 10 products with the highest sales totals. You've successfully created your first Top 10 filter!

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Method 2: Give Users Control with a Top N Parameter

What if your manager wants to see the Top 10, but the sales team wants to see the Top 5 or Top 20? Instead of creating separate dashboards, you can use a parameter to let users choose the "N" in "Top N" dynamically.

Step 1: Create the Parameter

A parameter is a workbook variable that you and your users can control. It allows you to accept and incorporate user-provided input into your calculations and filters.

• In the Data pane (usually on the left), right-click in an empty space and select Create Parameter...
• The Create Parameter window will open. Let's configure it:
• Click OK. You'll see your new "Select Top N" parameter appear in the bottom section of the Data pane.

Step 2: Connect the Parameter to the Filter

Now, we need to tell our filter to use the parameter's value instead of a fixed number like 10.

• Drag Product Name back to the Filters shelf (or right-click the existing one and select "Edit Filter").
• Go to the Top tab again and select "By field."
• This time, instead of typing a number into the box, click the dropdown arrow next to it. You will see your "Select Top N" parameter listed at the bottom. Select it.
• Make sure the rest of the rule is correct (e.g., "by Sales Sum"). Click OK.

Nothing seems to have changed yet, because the parameter's current value is 10. The final step is to make it interactive.

Step 3: Show the Parameter Control

• In the Data pane, find your "Select Top N" parameter.
• Right-click it and choose Show Parameter.

A small control box will appear on your dashboard or worksheet, usually on the right side. It will likely show up as a slider by default. Now, you or your end-users can drag the slider or type in a number to dynamically change the view between the Top 5, Top 12, Top 20, etc.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Method 3: The Robust Index() Function for Complex Filtering

Have you ever applied a Top 10 filter and then tried to filter by a specific product category, only to get fewer than 10 results? This happens because of Tableau's "Order of Operations." Standard dimension filters (like filtering for the "Technology" category) are applied before your Top N filter. So, Tableau first filters the data to only Technology products and then finds the Top 10 within that smaller subset.

To find the Top 10 products overall and then see which of those are in the "Technology" category, you need to use a table calculation like INDEX().

Step 1: Get the Rank with a Calculated Field

• Build your initial view again: Product Name on Rows, SUM(Sales) on columns, sorted descending.
• Create a new calculated field by right-clicking in the Data pane. Name it "Rank".
• The formula is incredibly simple:

INDEX()

• Click OK. INDEX() is a table calculation that returns the position (or index) of the current row in the partition.

Step 2: Add Rank to the View

• Drag your new "Rank" field to the Rows shelf, and place it just to the left of Product Name.
• By default, it will be a continuous (green) pill. Right-click on it and select Discrete to turn it into a blue pill. This turns it into numbered labels (1, 2, 3...) instead of an axis.

You can now see the numerical rank next to each product name.

Step 3: Filter Using the Rank

• Now, instead of using the built-in Top N filter, we will filter on our "Rank" calculation. Drag the "Rank" field a second time, this time to the Filters shelf.
• A "Filter Field" dialog box will appear. Select a range of values. A good default is 1 to 10.
• Click OK.

Your view now shows the Top 10. Because this is a table calculation filter, it’s applied late in Tableau's Order of Operations. This means you can now add other dimension filters (like Category = 'Technology') and the Top 10 calculation will remain correct for your overall dataset.

Method 4: Show the Top 10 and Group Everything Else as 'Other'

Often, you want to highlight your top performers but not completely ignore the rest of the data. A common solution is to show the Top 10 as individual items and group all remaining items into a single category called "Other." This preserves the totals while keeping the viz tidy. You can't achieve this easily with a simple filter, but you can with a Set.

Step 1: Create a Set for Your Top 10

• In the Data pane, find the dimension you want to analyze (e.g., Product Name).
• Right-click on it and go to Create > Set...
• Give the set a name, like "Top 10 Products by Sales."
• In the dialog box, go to the Top tab. This should feel familiar!
• Define your rule: By field | Top | 10 | by Sales | Sum.
• Click OK. A new Set will appear in the Data pane. A Set simply buckets every product into two groups: those "IN" the set (the Top 10) and those "OUT" of the set.

Step 2: Create a Calculated Field to Group the Results

Now we use a calculated field to leverage this IN/OUT grouping.

• Create a new calculated field and name it "Top Products & Others."
• Use the following formula:

IF [Top 10 Products by Sales] THEN [Product Name] ELSE "Other" END

This simple logic states: "If a product is IN our 'Top 10 Products by Sales' set, then show its actual name. For everything else (those outside the set), label them as 'Other'."

Step 3: Build a New Visualization

• Drag your new calculated field, "Top Products & Others," to the Rows shelf.
• Drag SUM(Sales) to the Columns shelf.
• Sort the chart descending.

Voila! You now have a chart displaying bars for each of your Top 10 products and a final bar, "Other," which aggregates the sales of all remaining products. It's a clean and comprehensive way to view your data.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Final Thoughts

Mastering these different methods for filtering the Top 10 in Tableau will significantly enhance your ability to build focused and insightful dashboards. From a simple click-and-drag-filter to using dynamic parameters and powerful sets, you have an entire toolkit for highlighting the data that truly matters.

While Tableau provides deep control for creating these views, the goal is always to get to the insight faster. We built Graphed to cut down the time it takes to get from raw data to a clear answer. Instead of navigating menus, creating parameters, and writing calculations, you can simply ask in plain English: “Show me a chart of my Top 10 products by sales and group the rest as Other.” Our AI data analyst builds the interactive chart for you in seconds, connected directly to your live data sources like Shopify or Google Analytics, letting you skip the technical setup and get straight to making decisions.