Description



In a pivot table in Google Sheets, you can group data to get a different view. For example, say you have a pivot table showing total sales by region. You can group the total sales for the east and west regions so you can see their combined subtotal.

You can manually group data or do it automatically using a rule.

Note: You can’t apply a pivot group rule if you’ve already created a manual group on the same row or column item (and vice versa).


Instructions


Manually group data

  1. In Sheets, open an existing pivot table or create a new one.
  2. Select the row or column items you want to group together.
  3. Right-click a selected item and then click Create pivot group.
  4. (Optional) To ungroup, right-click a grouped item and click Ungroup pivot items.

Group data automatically using a rule
  1. In Sheets, open an existing pivot table or create a new one.
  2. If your items are numbers, right-click the row or column items you want to group with a rule and click Create pivot group rule.
  3. Choose an interval size.
  4. (Optional) Choose when your group starts and ends.
  5. Click OK.
  6. (Optional) To ungroup, right-click a grouped item and click Ungroup pivot items.