How to Format Grand Total in Tableau

Getting your Grand Totals to look just right in Tableau can feel surprisingly tricky. They often blend in with the rest of your data, but making them stand out is essential for a clear, professional report. This guide walks you through everything from simple color changes to more advanced techniques for complete control over how your grand totals are displayed.

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

First, What Are Grand Totals in Tableau?

In Tableau, grand totals summarize all the data in a particular row or column. When you have a table showing sales by region on rows and by product category on columns, you can add a grand total row at the bottom to see the total sales across all regions, and a grand total column on the right to see the total sales across all product categories. They are a one-click way to see the big picture alongside the details.

By default, they use the same aggregation as the rest of your view (like SUM or AVG). It’s important to remember that Tableau calculates these totals based on the underlying data, not by simply adding up the numbers you see in the table. This is a key point that often trips up new users - the total isn't a sum of the displayed aggregated marks, but a separate aggregation across all the relevant 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

How to Quickly Enable Grand Totals

Before you can format your totals, you need to turn them on. Luckily, this is straightforward. Let’s say you have a basic text table showing Sales by Sub-Category.

1. Navigate to the top menu bar.
2. Click on Analysis.
3. Hover over Totals in the dropdown menu.
4. From here, you have a few options:

Just select the ones you need, and they'll instantly appear in your visualization.

Formatting Grand Totals Using the Format Pane

The easiest way to change the appearance of your grand totals is with the built-in Format pane. This panel gives you control over fonts, colors, shading, and alignment without needing any complex calculations.

Step 1: Open the Format Pane

Right-click anywhere inside your table (on a number, a header, or even the grand total itself) and select Format. This will open the Format pane on the left side of your screen. This powerful menu lets you customize nearly every visual element of your worksheet.

Step 2: Navigate to Totals Settings

Inside the Format pane, you'll see a row of icons at the top (Font, Alignment, Shading, etc.). Click the Font icon (A) to get started. By default, you'll be editing the entire sheet. Look for the dropdown menu at the top of the pane that probably says “Sheet."

Click it and find the section labeled Totals. This is where you can make changes that will only apply to the grand total cells in your view. If you have subtotals enabled, you’ll see "Grand Total" as its own specific option.

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

Step 3: Customize Your Totals

Now you can get to styling. Within the Totals section, you can adjust several elements:

• Font: This is a common one. You can make your Grand Total font bold to help it stand out, change its color to be distinct from the other values, or increase the size.
• Pane: Located under the Font settings, Pane controls the text alignment and style for the data values in the Grand Total row/column. You can bold the numbers to draw attention to them.
• Header: This controls the formatting for the label "Grand Total." You could change the label's color or font style separately.
• Shading: Click the paint bucket icon at the top of the Format pane to access shading. With Totals selected in the dropdown, you can now change the background color of the grand total row or column. A light grey shading is a popular and effective way to visually group the total.
• Borders: Click the borders icon (four-paned window). In the 'Total' dropdown, select 'Row Grand Total'. From there, you can add a top border to your grand total row in the 'Pane' section to cleanly separate it from the rest of the data.

Example: Making a Grand Total Bold with a Grey Background

1. Right-click your table and choose Format.
2. In the Format pane, select the paint bucket icon for Shading.
3. From the dropdown at the top, select Grand Total.
4. Choose a light grey color from the palette for the 'Pane' area. Your grand total row/column background will instantly change color.
5. Next, click the font icon (A).
6. Ensure Grand Total is still selected in the dropdown.
7. In the worksheet dropdown, select a bold font. Now the numeric values will be bolded.

Advanced Grand Total Formatting Techniques

Sometimes, the built-in Format pane isn't enough. You might want to use a different calculation for your total, create more distinct visual separation, or apply conditional formatting. Here are a couple of powerful techniques for those situations.

Technique 1: Using a Table Calculation for a Custom Total

What if you want to show the SUM of sales for each category but the AVERAGE of sales in the grand total? The default SUM aggregation won't allow this. But you can overwrite the grand total’s behavior with a table calculation.

Here, the SIZE() function is your friend. It returns the number of rows in a partition. For detail rows in your table, the size will be larger than one. For the Grand Total row, the size is always exactly one.

How to use 'SIZE()':

1. Create a new calculated field. Let's name it "Custom Sales Total".
2. Enter the following formula:

IF SIZE() = 1 THEN
    AVG([Sales])
ELSE
    SUM([Sales])
END

1. Drag your original SUM(Sales) measure off the Text/Label card in the Marks pane.
2. Drag your new Custom Sales Total calculated field onto the Text/Label card.
3. Click on the pill for your new calculated field, select Compute Using, and choose Table (Down).

Now, your table will show the sum of sales for each sub-category, but the grand total line at the bottom will display the average of all sub-category sales. This gives you much more analytical flexibility.

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

Technique 2: Creating a Separate Worksheet for Ultimate Control

For the ultimate formatting control, the most robust method is to create the grand total on its own separate worksheet and combine the two on a dashboard. This isolates the total from the main table, letting you style it however you want.

Step-by-Step Guide:

1. Build Your Detail Sheet: Create your main table, which we'll call "Sales by Category". Be sure grand totals are turned OFF (Analysis > Totals > Remove all Totals). Style it exactly how you want your detail rows to look.
2. Duplicate and Tweak for the Total Sheet: Right-click the "Sales by Category" worksheet tab and select Duplicate. Rename this new sheet to "Grand Total".
3. Isolate the Total: On your new "Grand Total" sheet, remove the dimension that breaks down the data (e.g., remove "Sub-Category" from the Rows shelf). Your view should now only contain a single aggregated number: the grand total.
4. Format the Total Sheet: Go wild. Because this sheet is separate, you can format it independently. Change the background color, make the font huge, edit the title to say "Overall Company Total," or whatever else you need. No changes here will affect your main detail sheet.
5. Combine on a Dashboard: Create a new dashboard.

This method requires a bit more setup but offers complete freedom. You are no longer constrained by Tableau's default row/column structure, which is perfect for highly stylized executive dashboards and reports.

Final Thoughts

Formatting Grand Totals in Tableau can range from a few simple clicks in the Format pane to using advanced calculations or dashboard structuring. Whether you just need to add a touch of bolding and color or require a completely custom total calculation and layout, one of these methods will get you the result you need for a polished and easy-to-read view.

Getting your reports to look just right in a tool like Tableau takes skill and practice. For times when you simply need to see your key numbers without wanting to spend time with format panes, we designed Graphed to do the heavy lifting. You can connect all your scattered marketing and sales data, then ask questions in natural language like, "Show me a dashboard of Shopify revenue by marketing channel for a grand total" to get a live, automated report built in seconds.