How to Do Grouping in Tableau

Trying to make sense of a long list of product sub-categories or countries is a fast way to get lost in the details. Grouping your data in Tableau lets you organize these messy details into clean, high-level categories so you can finally see the bigger picture. This guide will walk you through the different ways to create groups, from a simple visual approach to more advanced calculated methods.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is Grouping and Why Should You Use It?

In Tableau, grouping is the process of combining multiple members of a dimension into a single, higher-level category. Think of it like organizing a messy closet: instead of having individual socks, shirts, and sweaters scattered everywhere, you put them into organized buckets labeled "Socks," "Shirts," and "Outerwear."

You often need to do this with raw data. For example, your data might contain values like "USA," "U.S.A.," and "United States." While a human knows these are the same thing, Tableau sees them as three distinct items. Grouping allows you to combine them into a single, clean member called "United States," making your analysis accurate and your visualizations far less cluttered.

The main benefits of grouping are:

• Data Cleaning: Correct typos and combine variations of the same data point (e.g., "CA" and "California").
• Simplification: Condense a long list of dimension members into easier-to-manage categories (e.g., grouping 50 states into regions like "Northeast," "West Coast," etc.).
• Revealing Trends: Analyzing at a higher level can uncover trends that are invisible when you're stuck in the weeds. You might not see a pattern looking at 20 different sub-categories, but grouping them into "Office Supplies," "Technology," and "Furniture" might reveal that one category is dramatically outperforming the others.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 1: Visual Grouping in the View (The Quick and Easy Way)

This is the most direct and intuitive way to create a group. You do it right inside your visualization (the "view") by selecting the marks you want to combine. This method is perfect for quick, on-the-fly analysis when you spot something interesting in your chart.

Let’s use an example. Imagine you have a bar chart showing sales for every Sub-Category in the Sample - Superstore dataset. You notice a few items sales that you want to bundle together as "Core Office Supplies."

Step-by-Step Instructions:

1. Build Your Chart: Create a simple bar chart. Drag the Sub-Category dimension to the Rows shelf and the Sales measure to the Columns shelf.
2. Select Your Marks: In the bar chart (or directly on a text table's headers), select the dimension members you want to group. To select multiple members, hold down the Ctrl key (or Command key on a Mac) while you click on each one. For our example, select "Paper," "Envelopes," "Labels," and "Fasteners."
3. Create the Group: With your members selected, a tooltip will appear. Click the group icon, which looks like a paperclip. Alternatively, you can right-click on your selection and choose "Group."

That's it! Tableau instantly consolidates the selected items into a new, combined member. It will generate a default name based on the members you chose (e.g., "Paper, Envelopes, Labels & Fasteners"). On the Rows shelf, you'll see a new field has appeared: Sub-Category (group). This field is also now available in your Data pane on the left, ready to be reused.

To give it a cleaner name, simply right-click the newly created group member in your chart and select "Edit Alias." You can rename it to "Core Office Supplies."

Method 2: Grouping from the Data Pane

Creating a group from the Data pane is a more proactive way to organize your data. Instead of reacting to a visualization, you build the group first, allowing you to use it across multiple worksheets right from the start. This method is ideal when you already know how you want to segment your data before you build anything.

Let's say you want to group all your product sub-categories into three main categories you define yourself: "Office Essentials," "Furniture," and "Technology."

Step-by-Step Instructions:

1. Start the Group Action: In the Data pane on the left, find the dimension you want to group. In our case, this is Sub-Category.
2. Open the Group Dialog: Right-click on Sub-Category and select Create > Group...
3. Create Your First Group: The "Create Group" dialog box will appear, showing a list of all members in the Sub-Category dimension. Select the members you want in your first group (e.g., "Appliances," "Binders," "Envelopes," "Fasteners," "Labels," "Paper," "Storage," "Supplies"). After selecting them, click the Group button. Tableau will create a new grouped member and a default name you can rename. Double-click the name and change it to "Office Essentials."
4. Create More Groups: Now, do the same for the others. Select "Bookcases," "Chairs," "Furnishings," and "Tables," then click Group. Rename this one "Furniture." Finally, group the remaining items ("Accessories," "Copiers," "Machines," "Phones") into a "Technology" group.
5. Handle Ungrouped Items (Optional): If you have any remaining members that you didn't group, you can leave them as-is or you can check the box that says Include 'Other'. This creates a catch-all bucket for any members you didn't explicitly group, as well as any new members that appear in future data refreshes. It's great for keeping things tidy.
6. Finalize the Group: Click OK. You'll now see a new field in your Data pane called Sub-Category (group). You can drag and drop this field into any worksheet to analyze your data using these new, simplified categories.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Method 3: Grouping with Calculations (The Advanced Method)

Sometimes, your grouping logic is based on a rule or a condition, not a static list of members. For instance, what if you want to group sales transactions as "Large Sale," "Medium Sale," or "Small Sale"? You can't achieve this by manually selecting members. This is where a calculated field comes in.

While this isn't technically a "Group" in the same way Tableau defines it, it achieves the same result: classifying discrete dimension members or measure values into logical buckets.

Step-by-Step Instructions:

1. Create a Calculated Field: In the top menu, select Analysis > Create Calculated Field... or right-click in an empty area of the Data pane and select "Create Calculated Field..."
2. Name Your Calculation: Give your field a descriptive name, like "Sales Size."
3. Write the Formula: In the formula box, you'll use an IF-THEN statement to define your logic. For our example, we want to group SUM(Sales) into different sizes:

IF SUM([Sales]) > 1000 THEN "Large Sale"
ELSEIF SUM([Sales]) > 200 THEN "Medium Sale"
ELSE "Small Sale"
END

Important Note: An error message will show saying you can't mix aggregate (SUM) and non-aggregate comparisons in this function. This is a common Tableau hurdle. To resolve this, you need to apply the logic at a more granular level if possible, like against the [Sales] field per row instead of an aggregation. If you're using this type of aggregate calculation, you would need to adjust where and how you place it in the view, often in relation to the level of detail being displayed.

A more common use case is grouping dimension members programmatically. Let's group Sub-Categories a different way:

IF [Sub-Category] = "Paper" OR [Sub-Category] = "Envelopes" THEN "Paper Goods"
ELSEIF [Sub-Category] = "Chairs" OR [Sub-Category] = "Tables" THEN "Seating & Surfaces"
ELSE "Other"
END

1. Apply the Calculation: Click OK. The new "Sales Size" or "Product Group" dimension will appear in your Data pane. You can now use it in your visualizations just like any other dimension.

The beauty of this method is its dynamism. If the underlying data changes, your calculated field will automatically re-group everything based on the rules you defined. This makes it far more scalable than manual grouping.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Groups vs. Sets vs. Bins: What's the Difference?

As you get comfortable with Tableau, you'll run into three similar concepts: Groups, Sets, and Bins. They all help you organize data, but they serve different purposes. Knowing which to use will save you a lot of headaches.

• Groups: Use these for combining multiple dimension members into static, higher-level categories. The classic example is grouping states into regions. It's a many-to-one relationship based on a manually defined list.
• Sets: Use these to create two categories based on a condition: members that are IN the set and members that are OUT of the set. Sets can be static (like a group) or dynamic (e.g., a set of the "Top 10 Customers by Sales"). If your rules change, a dynamic set updates automatically. It's best used for comparison and filtering.
• Bins: Use these exclusively for measures (numeric data). Bins create evenly sized buckets for continuous data, which is perfect for building histograms. Examples include creating age brackets (20-29, 30-39, etc.) or grouping order sizes ($0-$50, $51-$100, etc.). You don't pick which members go where, you only define the bucket size.

Final Thoughts

Mastering grouping is a foundational skill for anyone serious about using Tableau effectively. It simplifies complex datasets, cleans up messy information, and helps you communicate insights clearly and concisely, whether you're using a quick visual method or a more robust calculated field.

We know that getting data into a tool like Tableau and then spending time clicking, dragging, and configuring is often half the battle. This manual work creates a bottleneck, where getting answers can take hours of report building. At Graphed, we're focused on eliminating that friction completely. Instead of building reports manually, you can simply connect your data sources and use plain English to ask what you want to see - like, "Show me my sales by product sub-category but group paper, envelopes, and labels together." We generate the dashboard for you in seconds, with live data, so you can spend less time wrangling your tools and more time acting on insights.