How to Add Total Columns to a Tableau Table

You've connected your data, dragged your pills onto the canvas, and built a beautiful and informative table in Tableau. Everything looks perfect, but one small thing is missing: a total column. Adding totals should be straightforward, but as many users discover, it can sometimes be surprisingly tricky. This guide will walk you through the methods for adding grand totals and subtotals, from the simple drag-and-drop to troubleshooting common issues and creating custom totals when the built-in features don't quite cut it.

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 Easiest Method: Using the Analytics Pane

Tableau’s Analytics pane is your quickest path to adding standard totals. It provides a simple drag-and-drop interface that handles most basic totaling needs in just a few seconds.

Let’s imagine you have a view showing Sales by Region and Category, like the table below:

You can see the sales for each category within each region, but you want to see the grand total for all regions and subtotals for each region individually. Here’s how to do it.

Step-by-Step Instructions:

1. Open the Analytics Pane: At the top of the Data pane (where your dimensions and measures are listed), you'll see two tabs: 'Data' and 'Analytics'. Click on 'Analytics'.
2. Drag Totals onto the View: In the Analytics pane, under the 'Summarize' section, you will see an option for 'Totals'. Click and drag this 'Totals' option and hover over your table.
3. Choose Your Totals: As you drag 'Totals', Tableau will show you a small pop-up box with different choices. You can drop 'Totals' onto 'Subtotals', 'Column Grand Totals', or 'Row Grand Totals'.
4. Adjust as needed: Select the appropriate total type by dropping the 'Totals' onto the desired option.

For most day-to-day use cases, the Analytics pane is all you need. It’s visual, intuitive, and gives you immediate feedback on what your totals will look like.

The "Classic" Method: Using the Analysis Menu

Before the slick Analytics pane existed, the menu bar was the primary way to control totals. This method still works perfectly and can be a faster alternative if you already have your mouse at the top of the screen or prefer using menus.

How to Add Totals via the Top Menu:

1. Navigate to the top menu bar in Tableau.
2. Click on the Analysis menu item.
3. Hover over Totals. A sub-menu will appear with several options.
4. From here, you can select:

Think of this as another path to the same destination. If a manager asks you to quickly add subtotals during a presentation, a few quick clicks in the Analysis menu can get it done without cluttering your screen with the side-pane.

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

Troubleshooting: Why Aren't My Totals Working?

Sometimes, you follow the steps perfectly, but your grand total doesn't show up, displays an asterisk (*), or just seems wrong. This is a common point of frustration, but is usually caused by one of a few predictable situations.

1. Totals with Blended Data

If you're using data blending (combining data from two or more different data sources in one sheet), you might see an asterisk (*) in your total column. This asterisk means that Tableau can’t compute a total in the way it normally would.

Why this happens: Data blending requires all data from the secondary source to be aggregated at the level of the linking field from the primary source. The grand total calculation, however, happens in the primary data source and doesn't always have a clear "single" value from the blended source to use. Essentially, there are multiple values it could use, so it displays an asterisk to indicate ambiguity.

How to fix it: The best solution is often to create a proper relationship or join your data sources in the 'Data Source' tab instead of blending them on the worksheet, if possible. Relationships are much more flexible and handle totals correctly.

2. Totals with Table Calculations

This is another classic Tableau moment. You create a table calculation like Percent of Total, add a grand total, and see "100%" in the total column - even when filtering your data. The total is calculating the total of the underlying values (the full sum), not summing up the percentages you see in the column.

Why this happens: Tableau calculates the grand total based on the original, underlying data, not on the aggregated results in your view. For a 'Percent of Total' calculation, the grand total is literally the "percent of total of the total" - which is always 100%.

How to work around it: Edit your Table Calculation settings. Right-click on your calculation, select Edit Table Calculation, and check how it is being computed. Sometimes changing the computation direction (e.g., Table Down vs. Pane Down) helps. For more complex cases, you may need a workaround with Level of Detail (LOD) calculations to pre-calculate the values you want to see summed.

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

3. Totals on Discrete Measures

Grand Totals only work with Measures (the fields with green pills that are inherently numeric and aggregable). If you've converted a number to be a Dimension (a blue pill), you won't be able to total it. Make sure the field you’re trying to total is a continuous measure.

Advanced Control: Formatting and Customizing Your Totals

Once you’ve successfully added totals, you can also customize how they look and what they are called. This is key for creating polished, presentation-ready tables.

Changing a Total's Label

Don't like the default "Grand Total" label? You can change it.

1. Right-click on the "Grand Total" label in your table's header.
2. Select Format….
3. In the formatting pane on the left, under the 'Total' section, you'll see a 'Label' field.
4. Type your custom label, like "Company-Wide Total" or "All Regions," and press Enter.

Changing a Total's Formatting

Making your totals stand out visually is also easy. The same formatting pane lets you control the style.

Still in the 'Format' pane:

• Open the 'Total' section if it's not already.
• Here you can change the font, make it bold, increase the size, or change the alignment.
• In the 'Shading' dropdown, you can also give the total row or column a different background color to separate it from the rest of the data.

The Ultimate Power Move: Custom Totals with Calculated Fields

When the standard SUM-based total won't do, you can take matters into your own hands with calculated fields, specifically Level of Detail (LOD) expressions.

Imagine you need a total, but instead of a standard sum, you need a different aggregation like an average, or you only want to total a specific subset of your data. LODs let you break free from the structure of your visualization to calculate values.

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

Example: Showing Total Company Sales on Every Row

What if, for comparison, you wanted a column repeating the total sales for the entire company next to each category's sales? A standard total can't do this, but an LOD can.

1. Create a new calculated field. Go to Analysis > Create Calculated Field.
2. Name it something like "Total Company Sales".
3. Enter the following FIXED LOD formula:

{ FIXED : SUM([Sales]) }

1. Click OK.

This formula tells Tableau: "For the entire dataset, no matter what filters or dimensions are in the view, calculate the total sum of sales." When you drag this new field onto your view as a measure, it will create a column where the value is the same in every row - the grand total!

From here, you can create more advanced calculations, like the variance from the total or the percentage each category contributes, giving you much more analytical power than a simple total row at the bottom.

Final Thoughts

Adding total and subtotal columns in Tableau ranges from a simple drag-and-drop exercise to a slightly more advanced challenge involving custom calculations. By understanding how to use the Analytics pane, Analysis menu, and troubleshoot common issues with table calculations or blended data, you can control nearly every aspect of how your tables are summarized. Don't be afraid to use formatting options and Level of Detail expressions to create tables that are not just accurate, but also clear and professional.

Knowing your way around a tool like Tableau is incredibly powerful, but we also recognize the learning curve and time commitment it requires. Instead of spending hours clicking, dragging, and formatting a table for one specific report, what if you could just ask for what you need? As we build Graphed, our entire focus is on eliminating that friction. We built an AI data analyst that allows you to connect your data sources - like Google Analytics, Shopify, or Salesforce - and simply describe the report you want in plain English, empowering you to get from question to insight in seconds, not hours.