How to Remove SUM in Tableau

Dragging a field into your Tableau view and seeing it instantly become SUM(Sales) or SUM(Profit) is a universal experience for anyone learning the tool. This article explains exactly why Tableau does this and shows you several ways to remove the SUM function to see your data exactly how you want 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

Why Tableau Automatically Adds SUM() to Your Numbers

Before addressing the "SUM issue," it's helpful to understand why it happens in the first place. Tableau is designed for data visualization and summarization, not just as a raw data viewer. To create charts and graphs effectively, it needs to aggregate your data.

In Tableau, data fields are categorized into two main types:

• Dimensions: These are qualitative, categorical fields that you use to slice and dice your data. Think of things like Product Category, Customer Name, or Order Date. They are typically shown with a blue icon in the data pane.
• Measures: These are quantitative, numerical fields that can be measured and aggregated. Examples include Sales, Quantity, or Profit. They are typically shown with a green icon.

When you drag a Measure onto a worksheet, Tableau’s default behavior is to aggregate it using a sum. It assumes you want to see the total sales or total profit for the context you provide with your dimensions. For example, if you place SUM(Sales) on your Rows shelf and the 'Region' dimension on your Columns shelf, you get the total sales for each region. This behavior is the foundation of powerful data analysis, but sometimes you just want to see the individual data points.

Method 1: Turn Off Aggregation Entirely

The most direct way to "remove SUM" is to tell Tableau to stop aggregating measures altogether. This switches your view from a summary of your data to a row-level representation, where each mark on your visualization corresponds to a single row in your data source.

This is perfect for when you want to build a scatter plot to see the relationship between two numerical values or view a detailed list of every single transaction.

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 Disaggregate Measures:

1. Navigate to the top menu bar in your Tableau worksheet.
2. Click on the Analysis menu.
3. Look for the option labeled Aggregate Measures. You'll see it has a checkmark next to it by default.
4. Click on Aggregate Measures to uncheck it.

Instantly, you'll see your visualization change. The pills for your measures in the Rows and Columns shelves will no longer have the SUM() prefix. Instead of seeing grouped-up totals, you'll see a mark for every single record in your dataset. For instance, if you have Sales and Profit on the shelves, this will create a scatter plot showing each individual transaction's profit and sales value.

Heads Up: While incredibly useful for detailed analysis, disaggregating data can impact performance. If your dataset contains millions of rows, asking Tableau to plot a mark for every single one can make your workbook slow to load and interact with.

Method 2: Change the Aggregation Type

Sometimes, your goal isn't to remove aggregation entirely but to use a different type of calculation other than SUM. You might be more interested in the average sale price, the highest sale value, or the total number of transactions.

Tableau offers many different aggregation functions. Instead of SUM, you can easily switch to:

• Average (AVG): Calculates the average value of the numbers.
• Median: Finds the middle value in the range of numbers.
• Count (CNT): Counts the total number of rows.
• Count Distinct (CNTD): Counts the number of unique "things." For example, CNTD(Customer ID) would give you the number of unique customers.
• Minimum (MIN): Shows the smallest value.
• Maximum (MAX): Shows the largest value.

How to Change the Aggregation:

1. On your worksheet, find the measure pill you want to change (e.g., SUM(Sales) on the Rows shelf).
2. Right-click on the pill.
3. In the context menu that appears, hover your cursor over the Measure option.
4. A sub-menu will fly out showing all the available aggregation types. Select the one that fits your analysis, such as Average or Median.

The pill will update immediately, and your visualization will change to reflect the new calculation. This allows you to stay in an aggregated summary view while telling much more nuanced stories about your data beyond simple totals.

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: Convert a Measure into a Dimension

This method is for situations where a numerical field should not be aggregated at all because it acts as a categorical label or an identifier. Classic examples include Order ID, Customer ID, or Year.

If you see a field like Order ID in the Measures section of your data pane, Tableau will try to SUM(Order ID) if you use it, which is nonsensical. An Order ID of 500 isn't quantitatively larger than an Order ID of 250, they are just unique labels. The fix is to reclassify this field as a Dimension.

How to Convert a Measure to a Dimension:

1. Go to the Data Pane on the left side of your screen.
2. Locate the numerical field under the "Measures" section that you want to change (it will have a green # icon).
3. Right-click on the field name.
4. In the context menu, select Convert to Dimension.

You'll see the field jump up to the "Dimensions" section and its icon will turn blue. Now, when you drag it into your view, Tableau will treat it as a categorical label, listing out each unique ID instead of trying to sum them up.

Alternatively, you can simply click and drag the field from the Measures section and drop it directly into the Dimensions section.

Method 4: Control Aggregation at the Pill Level

What if you want to use a field as a discrete label in one chart but as an aggregated number in another? Instead of permanently changing its status in the Data Pane, you can control its behavior directly on the shelf. This gives you more flexibility per worksheet.

Using the "Dimension" Pill Setting

You can tell a specific pill to behave as a Dimension just for that one use without changing the underlying data model.

1. Drag a measure, like SUM(Year), onto a shelf.
2. Right-click the green pill.
3. Select Dimension from the top of the context menu.

The pill will turn blue and display a list of every distinct year value, rather than a single aggregated bar representing the sum of years.

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

Using the ATTR() Function

Attribute, or ATTR(), is a special aggregation that returns a value if and only if all the rows in that particular partition have the exact same value. If there are multiple different values, it returns an asterisk (*).

ATTR() is useful when you want to display a label at a certain level of detail but you know it should be unique. For example, if you drill down your view to the OrderID level, you can use ATTR([Customer Name]) to show the customer's name. At this level of detail, each OrderID has only one associated customer name, so it will display correctly.

A Practical Walkthrough: Viewing Individual Sales Transactions

Let's tie these concepts together. Imagine you have a dataset with every sales transaction and you want to build a simple table showing each one, not totals.

1. Drag the Order ID and Product Name dimensions to the Rows shelf. You'll get a list of all products for each order.
2. Now, drag the Sales measure to the text label on the Marks Card. By default, it will appear as SUM(Sales), showing the total sales for each product within each order. This isn't what we want.
3. Go to the top menu and click Analysis > uncheck Aggregate Measures.
4. Your view immediately updates! The SUM(Sales) pill now just says Sales. You are now seeing the individual sale amount for each specific product within each specific order, effectively showing you the raw-level detail.

This simple example demonstrates how quickly you can pivot from a summarized view to a detailed, row-level inspection by toggling just one setting.

Final Thoughts

Mastering how Tableau handles aggregation is a foundational step in becoming proficient with the tool. Understanding that SUM() is the default for a reason allows you to decide when to lean into aggregations for powerful summaries and when to disaggregate or change the calculation to uncover detailed insights.

Instead of wrestling with concepts like dimensions, measures, and aggregations, we built Graphed to do the heavy lifting for you. You can connect your data sources and simply ask in plain English, "Show me a detailed list of every sale from last quarter," and it will automatically generate the correct table without you ever needing to click on a menu. It handles the nuances behind the scenes, so you can go straight from question to insight in seconds.