How to Remove Totals in Tableau

Tableau's automatic totals and subtotals are fantastic for getting a quick summary of your data, but they don't always fit the story you're trying to tell. Sometimes, a grand total can be misleading or clutter a clean visualization, leaving you searching for a way to remove it. This guide covers several practical methods for removing totals and subtotals in Tableau, from the single-click solution to more granular techniques for precise control over your tables and charts.

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

The Simplest Method: Using the Analysis Menu

The fastest way to remove all grand totals from your worksheet is through the main toolbar. This is the perfect approach when you've built a table and realize you don't need the summary rows or columns at all. It's a global switch for the entire sheet.

Here's how to do it:

1. Navigate to the Analysis menu in the top toolbar of your Tableau worksheet.
2. Hover your mouse over Totals. A sub-menu will appear with several options.
3. You'll see checkmarks next to "Show Row Grand Totals" and/or "Show Column Grand Totals." Simply click to uncheck the ones you want to remove.

That's it. Tableau will instantly remove the corresponding total from your view. If you want to bring it back later, just follow the same steps and re-check the option.

For example, imagine you have a simple text table showing Sales by Category and Sub-Category. Tableau might automatically add a column grand total summing up all sales and row grand totals for each category. Using the Analysis menu lets you turn these off with just two clicks, cleaning up the view instantly.

Managing Subtotals for Your Dimensions

When you add multiple dimensions to your rows or columns, Tableau provides subtotals to summarize each section. For instance, if you have Region and then State on the Rows shelf, Tableau can show a subtotal for each region. These are handy but can also create unnecessary clutter if your table is already complex. Just like grand totals, you have a couple of ways to remove them.

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

Removing All Subtotals at Once

If you want to remove every subtotal on your sheet, you can use the Analysis menu again:

1. Go back to the Analysis menu.
2. Hover over Totals.
3. Click on Remove All Subtotals.

This action will remove every automatically generated subtotal, leaving only the detailed rows and any grand totals you've left enabled.

Removing Subtotals for a Specific Dimension

Sometimes you only want subtotals for certain dimensions. Perhaps you need a subtotal for each Region but not for each Product Category within it. Tableau allows you to control this at the individual field (or "pill") level.

Follow these steps:

1. Locate the dimension pill on your Rows or Columns shelf for which you want to remove subtotals.
2. Right-click the pill.
3. In the context menu that appears, you will see a checkmark next to Subtotals. Click it to deselect it.

The subtotals associated with that specific dimension will disappear, while any subtotals for other dimensions will remain. This gives you precise control over which levels of your hierarchy get a summary row, helping you build a cleaner, more focused report.

How to Remove Totals for a Single Measure

What if you want to keep the Grand Total row but remove the total for just one specific measure? This is a very common scenario. Imagine a table showing sales, profit, and profit ratio by product.

• A SUM(Sales) total makes sense.
• A SUM(Profit) total makes sense.
• A SUM(Profit Ratio) total does not make sense. Profit Ratio is an average, and summing averages is rarely a meaningful metric. The total would be an inflated, incorrect number.

In this case, you don't want to remove the entire total row, you just want to hide the misleading total for the Profit Ratio column. Here's how you can do it:

1. In your view, find the measure you want to modify on the Marks card (it will typically be under tooltip or text). It will likely be a green pill.
2. Right-click on that measure pill.
3. From the context menu, select Total Using (Automatic).
4. In the sub-menu that appears, select Hide.

Tableau will now show a blank space in the Grand Total row for that specific measure but will continue to display the totals for all your other measures. This small adjustment makes your reports more accurate and prevents stakeholders from drawing the wrong conclusions from flawed summary numbers.

Troubleshooting: Why is the 'Totals' Option Grayed Out?

At some point, you'll likely run into a situation where you go to the Analysis menu, but the options for "Totals" are grayed out and unclickable. This is a common point of frustration, but it almost always has a logical explanation. Here are the most frequent culprits:

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

1. Your Data Is Disaggregated

Tableau's totaling features only work on aggregated data. By default, Tableau aggregates measures (e.g., SUM of Sales). However, if you've disaggregated your data, Tableau displays every single row from your data source. Since there's nothing to aggregate, there's nothing to total.

To check this, go to the Analysis menu. If Aggregate Measures is unchecked, your data is disaggregated. Click it to turn aggregation back on, and your Totals options should become available.

2. The View Contains Blended Data

Data blending is a powerful feature, but it comes with limitations, especially regarding totals. Grand totals and subtotals will often be unavailable or behave unexpectedly when working with data from multiple sources in a single sheet. The rules can be complex, but generally, Tableau has trouble calculating a total when dimensions from the secondary data source are involved in the view's structure.

If your totals are grayed out and you are blending data, that is almost certainly the cause. The best workaround is to consider using a data join or relationship in the Data Source tab instead of blending if your analysis and data structure allow for it.

3. You're Using Certain Table Calculations

Table calculations like INDEX(), RANK(), or FIRST() operate on the visualization itself, not the underlying data. Because of how they are computed, Tableau can't generate a standard total for them. If your view is built primarily around table calculations, the Totals feature may be disabled.

The alternative in these scenarios is often to use a Level of Detail (LOD) expression, which allows you to compute aggregations at different levels of granularity within the data itself and can often be totaled correctly.

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

Advanced Technique: Hiding Totals With Custom Calculations

Sometimes the built-in hide and show options aren’t enough. You might have a specific formatting need or a complex calculation where you need absolute control over what appears in a total row. In these cases, you can use a calculated field to "trick" Tableau into hiding your totals.

One of the most popular ways to do this is with a calculation that checks if a cell is in a detail row or a total row. You can do this by comparing the minimum and maximum value of a dimension.

Let's say you want to hide the sales total for a view broken down by Category.

Create a new calculated field. Let's name it "Sales (No Total)".

Enter the following formula:

IF MIN([Category]) == MAX([Category]) 
THEN SUM([Sales]) 
END

Click OK.

How does this work?

• For any normal row in your table (e.g., the "Furniture" row), the minimum value of the Category is "Furniture" and the maximum value is also "Furniture". The condition MIN([Category]) == MAX([Category]) is true, so the calculation returns SUM([Sales]) for that row.
• For the Grand Total row, Tableau is looking across all categories. In that context, the minimum Category is "Furniture" and the maximum is "Technology". Since they are not equal, the condition is false, and the calculation returns nothing (NULL).

Now, just replace the SUM(Sales) pill in your view with your new "Sales (No Total)" pill. The values in your detail rows will look identical, but the grand total for that column will simply be blank.

Final Thoughts

Tableau gives you robust and flexible options for managing what your tables show. You can easily remove all totals and subtotals with the Analysis menu, or you can use right-click menus on your pills for more targeted control. Taking the few extra moments to hide misleading or unnecessary totals can dramatically improve the clarity and professionalism of your dashboards.

Learning all these specific clicks and calculations for different visualization tools requires a significant time investment - time that could be spent brainstorming your next campaign or analyzing what the data actually means. That's why we've focused on simplifying this process. With Graphed you can skip configuring charts manually. Just connect your data sources and ask questions like, "show sales by product category and region, and don’t include totals" or "create a weekly sales report" and get a beautiful, interactive dashboard in seconds. We automate the manual tasks so you can get straight to making data-driven decisions.