---
title: "Create row groups in grid reports"
slug: "create-row-groups-in-grid-reports-1"
updated: 2026-05-19T10:00:26Z
published: 2026-05-19T10:00:26Z
canonical: "help.quickbase.com/create-row-groups-in-grid-reports-1"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://help.quickbase.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Create row groups in grid reports

Group rows of records in grid reports to organize your data into collapsible categories.

![Screenshot of a grid report with 3 row groups labeled: In progress, Not started, and Completed](https://cdn.document360.io/dd260e4e-10bb-4b66-8fb3-5504c272b904/Images/Documentation/image-1776357693613.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A59%3A44Z&se=2026-10-30T12%3A59%3A44Z&sr=c&sp=r&sig=7U0O9IINgRchQxe62c15ss0g2lgP87MuQ9L39LH88Cw%3D)

## Create row groups

There are 3 places to create row groups for grid reports:

- In the **Columns** panel (on the right side of the report)
- In a column header’s **More** menu (3-dot icon)
- In the report’s settings page under **Sorting & grouping**

### In the Columns panel

1. Open the **Columns** panel (on the right side of the report).
2. Drag a column name from the list (using the dotted grip icon) into the **Row Groups** section.

![Screenshot of the Columns panel with a column called Status in the Row Groups section](https://cdn.document360.io/dd260e4e-10bb-4b66-8fb3-5504c272b904/Images/Documentation/image-1776357990286.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A59%3A44Z&se=2026-10-30T12%3A59%3A44Z&sr=c&sp=r&sig=7U0O9IINgRchQxe62c15ss0g2lgP87MuQ9L39LH88Cw%3D)

### In a column header’s More menu

1. In the header of the column whose field you want to group, select the 3-dot **More** menu icon.
2. Select **Group by** **[field name]**.

![Screenshot of the Group by field option in a column header's more menu](https://cdn.document360.io/dd260e4e-10bb-4b66-8fb3-5504c272b904/Images/Documentation/image-1778093908483.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A59%3A44Z&se=2026-10-30T12%3A59%3A44Z&sr=c&sp=r&sig=7U0O9IINgRchQxe62c15ss0g2lgP87MuQ9L39LH88Cw%3D)

### In Report settings

1. Go to the **Reports & Charts** settings page by one of the following methods:
  1. Select the 3-dot menu next to the table name on the sidebar. Then, select **Reports & Charts**.
  2. Open the report you want to edit. Select the **Customize page** button in the page bar, and then select **Reports & Charts**.
2. Select your report.
3. Go to the **Sorting & Grouping** section.
4. Next to **Sort & group,** choose **Sort & group on other fields**.
5. Add a **Sort & group…** option, along with the field you want to group on the report.

## Add multiple group levels

Add multiple levels of grouping by dragging additional field columns into the **Row Groups** section in the **Columns** panel. This creates a hierarchy where row groups are nested within the row group above them. Reorder the hierarchy by dragging row groups in the **Columns** panel using the dotted grip icon.

![Screenshot of a grid report with a hierarchy of groupings: Status and Priority](https://cdn.document360.io/dd260e4e-10bb-4b66-8fb3-5504c272b904/Images/Documentation/image-1777925812592.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A59%3A44Z&se=2026-10-30T12%3A59%3A44Z&sr=c&sp=r&sig=7U0O9IINgRchQxe62c15ss0g2lgP87MuQ9L39LH88Cw%3D)

## Expand and collapse row groups

To expand or collapse individual row groups, use the **Expand**/**Collapse** icon in the group heading. ![](https://cdn.document360.io/dd260e4e-10bb-4b66-8fb3-5504c272b904/Images/Documentation/image-1776347732397.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A59%3A44Z&se=2026-10-30T12%3A59%3A44Z&sr=c&sp=r&sig=7U0O9IINgRchQxe62c15ss0g2lgP87MuQ9L39LH88Cw%3D)

To expand or collapse all row groups at once, use the **Expand**/**Collapse** icon in the report heading.

![Example of a report with grouped rows, based on the Status field. The groups are labeled "In progress," "Not started," and "Completed"](https://cdn.document360.io/dd260e4e-10bb-4b66-8fb3-5504c272b904/Images/Documentation/image-1776286438669.png?sv=2026-02-06&spr=https&st=2026-10-30T11%3A59%3A44Z&se=2026-10-30T12%3A59%3A44Z&sr=c&sp=r&sig=7U0O9IINgRchQxe62c15ss0g2lgP87MuQ9L39LH88Cw%3D)

## **Set groups to be expanded or collapsed by default**

By default, groups in grid reports are expanded when first opened. Builders can change this setting in their [default report settings](/v1/docs/setting-reporting-defaults) under **Options**. This setting applies to each report in a given table unless overridden in a specific report’s settings.

To override the default report settings, open the specific report’s settings and go to **Sorting & Grouping** > **Group display**.