Can You Sum More Than One Field in Tableau?

The short answer is yes, you absolutely can sum more than one field in Tableau. It’s one of the most common and powerful ways to create new insights from your existing data. This article will walk you through the primary methods for adding fields together, from creating simple calculated fields to using built-in features for a quick total.

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 Sum Multiple Fields Together?

Before jumping into the “how,” let’s quickly cover the “why.” Combining fields is fundamental to data analysis because raw data often doesn't contain the exact metrics you need for your reports. By summing fields, you can create new, meaningful key performance indicators (KPIs).

Here are a few common scenarios where you’d need to sum fields:

• Total Revenue: Your data might have separate columns for Product Sales and Shipping Fees. To get the Total Revenue per transaction, you need to add them together.
• Total Marketing Spend: You might have data from different ad platforms in one source, with columns like Facebook Ad Spend and Google Ad Spend. Summing them gives you a complete picture of your digital ad costs.
• Cost of Goods Sold (COGS): You could calculate a simple COGS by summing a Material Cost field and a Labor Cost field.

In all these cases, you are creating a new, more valuable piece of information by combining existing data points. This is where Tableau's calculation capabilities shine.

Method 1: The Go-To Approach with Calculated Fields

The most flexible and common way to sum fields in Tableau is by using a Calculated Field. This creates a new field (a new measure) in your data pane that you can use in any worksheet, just like any of your original data fields.

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

Step-by-Step Instructions

Let's create a Total Spend calculation by summing Marketing Spend and Sales Team Costs.

1. With your Tableau workbook open, navigate to the Analysis menu at the top of an empty worksheet and select Create Calculated Field.... A calculation editor window will appear.
2. Name Your Calculation: In the top text box, give your new field a clear, descriptive name. We'll call ours "Total Spend." Descriptive names make your life much easier later on.
3. Write the Formula: In the larger formula box, you'll write the expression to sum your fields. Since these are likely already aggregated measures, you'll typically wrap them in a SUM() function. The formula would be:
4. Check for Errors: At the bottom of the calculation editor, Tableau will tell you if the calculation is valid. If it is, you'll see a message that says “The calculation is valid.” If not, it will give you a hint about what's wrong.
5. Click OK: Once the calculation is valid, click OK. You'll now see your new "Total Spend" field in the data pane under "Measures." It will have a small equals sign (=) next to the data type icon, indicating it's a calculated field.

That's it! You can now drag your new "Total Spend" measure onto your view (like Rows, Columns, or Text) to visualize it. This new field will calculate the sum dynamically based on the dimensions in your view (e.g., show Total Spend by Quarter, by Region, or by Product Category).

Pro Tip: Handling Null (Empty) Values with ZN()

What happens if one of your fields has a null (blank) value for a particular row? For example, if a specific month had marketing spend but no sales team costs? In that case, [Sales Team Costs] would be null, and any mathematical operation involving a null value results in a null. In short, 500 + null = null, which is probably not what you want.

To fix this, you can use the ZN() function, which stands for "Zero Null." This function checks if a value is null and, if it is, converts it to a zero. Otherwise, it returns the original value.

Your improved, more robust formula would look like this:

SUM(ZN([Marketing Spend])) + SUM(ZN([Sales Team Costs]))

This ensures that blanks are treated as zeros and don't break your summation.

Method 2: Row-Level Calculations

Sometimes, you need to sum values for each individual row of your data before you aggregate them. This is called a row-level calculation. For this, you create a calculated field without an aggregation function like SUM().

For example, imagine you have an e-commerce data set with columns for Price Per Item and Shipping Fee for every single order line.

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

When to Use Row-Level Calculations

If you wanted to find the total revenue for each line item (item price + shipping), you would create a calculated field named "Total Item Revenue" with this simple formula:

[Price Per Item] + [Shipping Fee]

When you use this new [Total Item Revenue] field in a view and aggregate it (for example, by taking the SUM([Total Item Revenue])), Tableau will first perform the + operation for every row, and then it will sum up all of those individual results.

The difference is subtle but important:

• Aggregate Calculation (Method 1): SUM([Sales]) + SUM([Profit]). This first sums up all sales, then sums up all profit, and finally adds those two results together.
• Row-Level Calculation (Method 2): [Sales] + [Profit]. When aggregated as SUM([Sales] + [Profit]), this first adds sales and profit for each row and then sums up those row-level results.

In most simple addition cases, both methods yield the same final answer. However, when you start using more complex calculations like division for percentages, the order of operations matters greatly.

Method 3: Summing Fields Visually with Totals and Measure Names

What if you don't need a new, reusable field? Maybe you just need to display the sum of a few measures in a simple table for a one-off analysis. In this case, you can use Tableau’s built-in "Measure Names" and "Measure Values" fields combined with totals.

Step-by-Step Instructions

1. Drag the dimension you want to analyze (e.g., Category) onto the Rows shelf.
2. Find the auto-generated field called Measure Names in your data pane and drag it to the Filters card. A dialog box will appear. Select only the measures you want to sum (e.g., check the boxes for Sales and Profit).
3. Drag the auto-generated Measure Values field to the Text card on the Marks shelf.
4. Finally, go to the Analysis menu at the top, navigate to Totals, and select Show Row Grand Totals or Show Column Grand Totals depending on your table's layout.

A new "Grand Total" labeled row or column will appear, showing the total for each measure. While this doesn't create a single, combined sum column, it's a very fast way to visually add up multiple measures without writing a single line of code.

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

Putting It Together: A Practical Example

Let's walk through a final, common business scenario. Imagine you have Shopify sales data and want to create a Gross Revenue KPI which is the sum of Net Sales and Tax.

1. Create the Calculated Field: Go to Analysis > Create Calculated Field.
2. Name It: Call it "Gross Revenue."
3. Write the Formula:
4. Click OK.
5. Build the Visualization:

You now have a clean line chart showing your total Gross Revenue over time, using a metric that didn't exist in your original data. You can now use this "Gross Revenue" field everywhere – in bar charts comparing product performance, in map visualizations showing regional sales, and in text tables for high-level summary reports.

Final Thoughts

As you can see, summing multiple fields in Tableau is a fundamental skill that opens up a world of analytical possibilities. Whether you're creating a permanent KPI using a calculated field or just needing to see a quick summary with Grand Totals, Tableau provides a flexible and powerful way to combine your data points and build more meaningful reports.

For many, the friction in data analysis isn't just one formula, it's the entire process of connecting data, building dozens of charts, and constantly updating reports. Here at Graphed, we created a tool that removes this manual work. Instead of clicking through menus and writing formulas, our platform allows you to connect your data sources (like Google Analytics, Shopify, and Salesforce) and simply ask questions in plain English, like "Show me a chart of total sales and tax by month." We build the dashboard for you in real-time, turning hours of tedious work into a 30-second conversation with your data.