How to Add Multiple Fields in Tableau

Working with multiple fields is the secret sauce to unlocking powerful insights in Tableau. While a single-bar chart showing total sales is useful, it's when you start adding layers - breaking down sales by region, then by product category, and finally by customer segment - that the real story in your data emerges. This guide will walk you through the essential techniques for adding multiple fields to your visualizations, turning flat charts into dynamic, multi-dimensional views.

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 Add Multiple Fields in Tableau?

Adding more data fields to a view lets you move from high-level summaries to granular details. It's the difference between asking "How much did we sell?" and "Which products are most popular with our top customers in the West region, and how does that compare to the East?"

Each field you add provides more context. It acts as a lens, allowing you to slice and dice your data in new ways. By combining fields, you can:

• Create Hierarchies: Drill down from a broad category into specific sub-categories (e.g., Technology > Phones > Accessories).
• Build Detailed Tables: Construct crosstabs or text tables that provide a comprehensive, multi-layered view of your numbers.
• Add Rich Context: Use marks like color, size, and shape to layer additional pieces of information onto your charts without making them feel cluttered.
• Spot Relationships: Compare multiple measures against multiple dimensions at once, making it easier to identify correlations and outliers.

Mastering this simple drag-and-drop mechanism is fundamental to nearly every dashboard you'll build in Tableau.

Understanding Dimensions and Measures in Tableau

Before you start dragging fields, it's critical to understand the distinction Tableau makes between Dimensions and Measures. In the Data pane on the left, Tableau helpfully separates your fields into these two categories.

Dimensions are qualitative, categorical fields that you use to slice and categorize your data. Think of them as the "what," "who," "where," and "when" in your analysis.

• Examples: Product Name, Region, Customer ID, Order Date, Ship Mode.
• How Tableau uses them: When you drag a dimension to the Rows or Columns shelf, it creates headers or labels. For example, dragging 'Region' to Columns will create four column headers: Central, East, South, and West.

Measures are quantitative, numerical fields that can be aggregated. They are the numbers you want to analyze and are usually the answer to questions like "how much?" or "how many?".

• Examples: Sales, Profit, Quantity, Discount, Shipping Cost.
• How Tableau uses them: When you drag a measure to the view, Tableau automatically applies an aggregation (like SUM, AVG, MIN, or MAX) and typically creates an axis.

Understanding this difference is key because combining multiple dimensions in Rows/Columns creates a very different result than combining multiple measures.

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: Adding Multiple Fields to Rows and Columns

The most common method for visualizing multiple fields is by adding them to the Rows and Columns shelves. The order and placement of these pills directly control the structure of your visualization.

1. Stacking Dimensions in the Rows Shelf for a Hierarchical List

Let's start by building a simple text table with a nested hierarchy. Imagine we want to see Sales for each Category, broken down by Sub-Category.

1. Connect to your data source (we'll assume a standard sales dataset like Tableau's Superstore sample).
2. Drag the Category dimension from the Data pane to the Rows shelf. You will now see three rows: Furniture, Office Supplies, and Technology.
3. Next, drag the Sub-Category dimension and drop it onto the Rows shelf, to the right of the Category pill.
4. Finally, drag the Sales measure to the Text mark on the Marks card.

What you just did: You created a nested structure. Tableau first organizes the view by Category and then, within each category, it breaks it down further by Sub-Category. The arrangement of the pills from left to right on the shelf dictates this top-down hierarchy. Your view is now a detailed list showing sales for each specific sub-category, neatly grouped under its parent category.

2. Creating a Crosstab with Multiple Column Headers

Now, let's take this a step further and add fields to both Rows and Columns to create a crosstab, often called a matrix or pivot table.

1. Start with a new, empty sheet.
2. Drag the Category dimension to the Rows shelf.
3. Drag the Order Date dimension to the Columns shelf. By default, Tableau will aggregate this by year, creating a pill that says YEAR(Order Date).
4. Let's add another dimension to the columns. Drag the Region dimension and drop it on the Columns shelf to the left of YEAR(Order Date).
5. To fill the table with numbers, drag the Sales measure and drop it onto the Text mark on the Marks card.

What you just did: You've built a multi-level crosstab. The columns are first grouped by Region, and then within each region, they are broken down by YEAR(Order Date). The rows are broken down by Category. This allows you to easily compare year-over-year sales performance for each category across a specific region at a glance.

Pro Tip: Click the + icon on the YEAR(Order Date) pill to drill down into Quarters, Months, and Days!

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. Building a Multi-Level Matrix

You can add as many dimensions as you need to both shelves. Be mindful, however, that too many can make the visualization unreadable.

Let's add one more field to our previous example:

1. With the crosstab from the last step still active, drag the Segment dimension and drop it on the Rows shelf, to the right of the Category pill.

Now, your crosstab is even more granular. Each category in the rows is further broken down into Consumer, Corporate, and Home Office segments. This sophisticated matrix allows for precise comparisons, such as analyzing the sales trend for the "Consumer" segment within the "Technology" category in the "West" region over the last three years.

Going Beyond Rows and Columns: Adding Fields with Marks

The Rows and Columns shelves are not the only places to add fields. The Marks card offers a powerful way to encode additional data into your visualization using properties like color, size, detail, and tooltips.

Adding Another Dimension with Color

Color is one of the most effective ways to add another dimension to a chart. Let's build a stacked bar chart to illustrate this.

1. Start with a new sheet.
2. Drag Region to the Columns shelf.
3. Drag Sales to the Rows shelf. This creates a simple vertical bar chart showing total sales for each region.
4. Now, find the Segment dimension in the Data pane and drag it directly onto the Color mark on the Marks card.

Instantly, each bar in your chart is transformed. It's now segmented by color, representing the sales contribution of each customer Segment (Consumer, Corporate, Home Office). The total height of the bar remains the same (total sales for the region), but you can now see the proportional mix of a third dimension within that total.

Using Size and Detail for Dense Visualizations

Marks like Size and Detail are fantastic for adding fields to visualizations like scatter plots, where each individual mark represents a row of data.

Let's build a scatter plot analyzing individual products.

1. Drag the Profit measure to the Rows shelf and the Sales measure to the Columns shelf. Tableau will initially show a single dot, representing the sum of all sales and profit.
2. To break this down, we need to add a level of detail. Drag the Product Name dimension to the Detail mark on the Marks card. The single mark explodes into hundreds of marks, one for each product, plotted based on its total sales and profit.
3. Now, let's add a third measure. Drag the Discount measure and drop it onto the Size mark.

Your scatter plot is now encoding three separate measures. The position of each dot tells you its profit and sales (high-profit/high-sales products are in the top right), while the size of the dot now indicates the average discount that product received. This allows you to spot patterns, such as whether high-discount products tend to have lower profit margins.

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: Creating a Combined Field

Sometimes, instead of nesting two dimensions hierarchically, you want to treat their unique combination as a single dimension. For example, rather than having "Furniture" with "Bookcases" under it, you simply want a label called "Furniture, Bookcases." This is where a Combined Field comes in handy.

1. In the Data pane, find the two dimensions you want to combine. For this example, let's use Category and Sub-Category.
2. Hold down the Ctrl key (or Cmd on a Mac) and click on both Category and Sub-Category to select them.
3. Right-click on one of the selected fields and choose Create > Combined Field.
4. A new dimension named "Category & Sub-Category (Combined)" will appear in your Data pane.
5. You can now drag this new combined field into your view just like any other dimension. If you drag it to rows and put Sales on columns, you'll get a bar for every unique sub-category combination, labeled clearly (e.g., "Technology, Phones").

This is particularly useful for creating specific labels, sorting by the combined value, or using the combination in calculations.

Quick Tips for Working with Multiple Fields

As you build more complex views, keep these best practices in mind:

• Clarity Over Complexity: Just because you can add ten fields doesn't mean you should. Each field should add meaningful insight. If a field makes the view confusing, it's probably better left for a tooltip or a separate chart.
• Pill Arrangement Matters: Experiment by dragging and swapping the order of pills on the Rows and Columns shelves. Changing the order changes the hierarchy and can reveal new perspectives on the data.
• Leverage Hierarchies: For date or geographical data, use Tableau’s built-in hierarchies. Click the small + on a pill like YEAR(Order Date) to quickly drill down without dragging new fields.
• Use the Tooltip: If the view is getting crowded but you still want to provide extra info, drag those extra fields to the Tooltip mark. The details will appear on hover, keeping the main visualization clean while making the data available for exploration.

Final Thoughts

Adding multiple fields is the core workflow for creating everything from simple tables to intricate, insightful dashboards in Tableau. By mastering how to place dimensions and measures on the Rows, Columns, and Marks card, you can move past high-level summaries and start asking deeper analytical questions. This process of layering information is essential for telling a compelling and complete story with your data.

While Tableau is an incredibly powerful tool, this process - figuring out which pill goes where - can involve a fair bit of trial and error, especially when getting started. We designed Graphed to simplify this completely. Instead of building charts by hand, you can just state what you want to see. For instance, you could ask, "Create a stacked bar chart of sales by region, broken down by segment," and the chart is generated automatically with live data. It's about bridging the gap between your questions and the data-driven answers you need.