---
schema_version: "1"
id: 31abd09a97f3c1e9e51033235520361443b521e03c0a63d0fd8b50b5358e05cf
title: Correct Data Errors or Combine Dimension Members by Grouping Your Data
collection: tableau
version: current
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/current/en-gb/public/desktop/sortgroup_groups.md
canonical_url: https://help.tableau.com/current/public/desktop/en-gb/sortgroup_groups.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 5e8e3073b7eec315321625986e95f93cb22e64c9c8281e4e4178e32293d6f742
description: Correct data errors or combine dimension members by grouping data.
---
[Skip to main content](#main-content)

# Correct Data Errors or Combine Dimension Members by Grouping Your Data

If you are using groups to correct data errors (for example, to combine "CA" and "California") or to combine dimensions members (for example, to combine "East" and "West" regions), the easiest option is to select headers in the view.

1. Press and hold the CTRL or Shift key on the keyboard to multi-select headers in the view. On a Mac, press and hold the Command key.
2. To create a group, do one of the following:
    
    - On Tableau Desktop, click the Group button ![A paperclip attachment icon and a context menu icon.](/tableau/current/en-gb/public/desktop/en-gb/Img/ad-hoc1.png) on the toolbar, right-click and select Group or click the Group icon on the tooltip.
    - On Tableau Server or Tableau Cloud, click on the Group icon on the tooltip.
    
    ![A bar chart with two rows and three columns. The first column is labelled Sub-Category and contains the values Accessories, Appliances, Art, Binders.](/tableau/current/en-gb/public/desktop/en-gb/Img/ad-hoc2.png)

The selected members are combined into a single member. In this example, the view now shows the SUM(Sales) across all binders, envelopes and fasteners as a single mark. A default is automatically constructed using the combined member names. The dimension on the Rows or Columns shelf is replaced with the new grouped field.

![A bar chart with two columns. The first column is labelled "Sub-Category" and contains the subcategories of products. The second column is labelled "Sales" and contains the sum of sales for each subcategory.](/tableau/current/en-gb/public/desktop/en-gb/Img/ad-hoc3.png)