Grouping (React) Guide

Examples#

Want to skip to the implementation? Check out these React examples:

• Grouping

React Setup#

import { useTable, tableFeatures, columnGroupingFeature, createGroupedRowModel, aggregationFns } from '@tanstack/react-table'

const features = tableFeatures({ columnGroupingFeature })

const table = useTable({
  features,
  rowModels: {
    groupedRowModel: createGroupedRowModel(aggregationFns),
  },
  columns,
  data,
})

import { useTable, tableFeatures, columnGroupingFeature, createGroupedRowModel, aggregationFns } from '@tanstack/react-table'

const features = tableFeatures({ columnGroupingFeature })

const table = useTable({
  features,
  rowModels: {
    groupedRowModel: createGroupedRowModel(aggregationFns),
  },
  columns,
  data,
})

Grouping (React) Guide#

Grouping in TanStack table is a feature that applies to columns and allows you to categorize and organize the table rows based on specific columns. This can be useful in cases where you have a large amount of data and you want to group them together based on certain criteria.

Grouping can also affect column order. There are 3 table features that can reorder columns, which happen in the following order:

1. Column Pinning - If pinning, columns are split into left, center (unpinned), and right pinned columns.
2. Manual Column Ordering - A manually specified column order is applied.
3. Grouping - If grouping is enabled, a grouping state is active, and tableOptions.groupedColumnMode is set to 'reorder' | 'remove', then the grouped columns are reordered to the start of the column flow.

To use the grouping feature, add the columnGroupingFeature to your features and the groupedRowModel to your row models. The grouped row model is responsible for grouping the rows based on the grouping state.

import {
  useTable,
  tableFeatures,
  columnGroupingFeature,
  createGroupedRowModel,
  aggregationFns,
} from '@tanstack/react-table'

const features = tableFeatures({ columnGroupingFeature })

const table = useTable({
  features,
  rowModels: {
    groupedRowModel: createGroupedRowModel(aggregationFns),
  },
  // other options...
})

import {
  useTable,
  tableFeatures,
  columnGroupingFeature,
  createGroupedRowModel,
  aggregationFns,
} from '@tanstack/react-table'

const features = tableFeatures({ columnGroupingFeature })

const table = useTable({
  features,
  rowModels: {
    groupedRowModel: createGroupedRowModel(aggregationFns),
  },
  // other options...
})

When grouping state is active, the table will add matching rows as subRows to the grouped row. The grouped row will be added to the table rows at the same index as the first matching row. The matching rows will be removed from the table rows. To allow the user to expand and collapse the grouped rows, you can use the expanding feature.

const features = tableFeatures({ columnGroupingFeature, rowExpandingFeature })

const table = useTable({
  features,
  rowModels: {
    groupedRowModel: createGroupedRowModel(aggregationFns),
    expandedRowModel: createExpandedRowModel(),
  },
  // other options...
})

const features = tableFeatures({ columnGroupingFeature, rowExpandingFeature })

const table = useTable({
  features,
  rowModels: {
    groupedRowModel: createGroupedRowModel(aggregationFns),
    expandedRowModel: createExpandedRowModel(),
  },
  // other options...
})

Grouping state#

The grouping state is an array of strings, where each string is the ID of a column to group by. The order of the strings in the array determines the order of the grouping. For example, if the grouping state is ['column1', 'column2'], then the table will first group by column1, and then within each group, it will group by column2. You can control the grouping state using the setGrouping function:

table.setGrouping(['column1', 'column2']);

table.setGrouping(['column1', 'column2']);

You can also reset the grouping state to its initial state using the resetGrouping function:

table.resetGrouping();

table.resetGrouping();

By default, when a column is grouped, it is moved to the start of the table. You can control this behavior using the groupedColumnMode option. If you set it to 'reorder', then the grouped columns will be moved to the start of the table. If you set it to 'remove', then the grouped columns will be removed from the table. If you set it to false, then the grouped columns will not be moved or removed.

const table = useTable({
  features,
  rowModels: { groupedRowModel: createGroupedRowModel(aggregationFns) },
  // other options...
  groupedColumnMode: 'reorder',
})

const table = useTable({
  features,
  rowModels: { groupedRowModel: createGroupedRowModel(aggregationFns) },
  // other options...
  groupedColumnMode: 'reorder',
})

Aggregations#

When rows are grouped, you can aggregate the data in the grouped rows by columns using the aggregationFn column option. This is a string that is the name of a built-in aggregation function, or a custom aggregation function registered in the registry passed to createGroupedRowModel.

const column = columnHelper.accessor('key', {
  aggregationFn: 'sum',
})

const column = columnHelper.accessor('key', {
  aggregationFn: 'sum',
})

In the above example, the sum aggregation function will be used to aggregate the data in the grouped rows. By default, numeric columns will use the sum aggregation function, and non-numeric columns will use the count aggregation function. You can override this behavior by specifying the aggregationFn option in the column definition.

There are several built-in aggregation functions that you can use:

• sum - Sums the values in the grouped rows.
• count - Counts the number of rows in the grouped rows.
• min - Finds the minimum value in the grouped rows.
• max - Finds the maximum value in the grouped rows.
• extent - Finds the extent (min and max) of the values in the grouped rows.
• mean - Finds the mean of the values in the grouped rows.
• median - Finds the median of the values in the grouped rows.
• unique - Returns an array of unique values in the grouped rows.
• uniqueCount - Counts the number of unique values in the grouped rows.

Custom Aggregations#

You can define custom aggregation functions in the registry that you pass to createGroupedRowModel. The registry is a record where the keys are the names of the aggregation functions, and the values are the aggregation functions themselves. You can then reference these aggregation functions by name in a column's aggregationFn option.

const table = useTable({
  features,
  rowModels: {
    groupedRowModel: createGroupedRowModel({
      ...aggregationFns,
      myCustomAggregation: (columnId, leafRows, childRows) => {
        // return the aggregated value
      },
    }),
  },
  // other options...
})

const table = useTable({
  features,
  rowModels: {
    groupedRowModel: createGroupedRowModel({
      ...aggregationFns,
      myCustomAggregation: (columnId, leafRows, childRows) => {
        // return the aggregated value
      },
    }),
  },
  // other options...
})

In the above example, myCustomAggregation is a custom aggregation function that takes the column ID, the leaf rows, and the child rows, and returns the aggregated value. You can then use this aggregation function in a column's aggregationFn option:

const column = columnHelper.accessor('key', {
  aggregationFn: 'myCustomAggregation',
})

const column = columnHelper.accessor('key', {
  aggregationFn: 'myCustomAggregation',
})

TypeScript Note: For aggregationFn: 'myCustomAggregation' string references to typecheck, augment the AggregationFns interface with a declare module block:

tsx

declare module '@tanstack/react-table' {
  interface AggregationFns {
    myCustomAggregation: AggregationFn<typeof features, MyData>
  }
}

declare module '@tanstack/react-table' {
  interface AggregationFns {
    myCustomAggregation: AggregationFn<typeof features, MyData>
  }
}

Alternatively, skip the registry and the augmentation entirely by passing the function directly to the aggregationFn column option.

Manual Grouping#

If you are doing server-side grouping and aggregation, you can enable manual grouping using the manualGrouping option. When this option is set to true, the table will not automatically group rows using getGroupedRowModel() and instead will expect you to manually group the rows before passing them to the table.

const features = tableFeatures({ columnGroupingFeature })

const table = useTable({
  features,
  rowModels: {}, // no groupedRowModel needed for manual grouping
  // other options...
  manualGrouping: true,
})

const features = tableFeatures({ columnGroupingFeature })

const table = useTable({
  features,
  rowModels: {}, // no groupedRowModel needed for manual grouping
  // other options...
  manualGrouping: true,
})

Note: There are not currently many known easy ways to do server-side grouping with TanStack Table. You will need to do lots of custom cell rendering to make this work.

Controlled Grouping State#

If you need access to the grouping state in other parts of your application, you can own the grouping state slice yourself. The recommended way in v9 is an external atom passed through the atoms table option. Atoms preserve fine-grained subscriptions, and the grouping value can be read anywhere in your app (such as in a query key for server-side grouping) without forcing the component that owns the table to re-render.

import { useCreateAtom, useSelector } from '@tanstack/react-store'
import type { GroupingState } from '@tanstack/react-table'

const groupingAtom = useCreateAtom<GroupingState>([])

// subscribe to the atom wherever you need the value
const grouping = useSelector(groupingAtom)

const table = useTable({
  features,
  rowModels: { groupedRowModel: createGroupedRowModel(aggregationFns) },
  // other options...
  atoms: {
    grouping: groupingAtom, // grouping APIs now update groupingAtom
  },
})

import { useCreateAtom, useSelector } from '@tanstack/react-store'
import type { GroupingState } from '@tanstack/react-table'

const groupingAtom = useCreateAtom<GroupingState>([])

// subscribe to the atom wherever you need the value
const grouping = useSelector(groupingAtom)

const table = useTable({
  features,
  rowModels: { groupedRowModel: createGroupedRowModel(aggregationFns) },
  // other options...
  atoms: {
    grouping: groupingAtom, // grouping APIs now update groupingAtom
  },
})

Alternatively, the v8-style state.grouping plus onGroupingChange pattern is still supported. It can be convenient for simple integrations or when migrating v8 code, but it is less fine-grained than external atoms. See the Table State Guide for a deeper comparison.

const [grouping, setGrouping] = useState<GroupingState>([])

const table = useTable({
  features,
  rowModels: { groupedRowModel: createGroupedRowModel(aggregationFns) },
  // other options...
  state: {
    grouping,
  },
  onGroupingChange: setGrouping,
})

const [grouping, setGrouping] = useState<GroupingState>([])

const table = useTable({
  features,
  rowModels: { groupedRowModel: createGroupedRowModel(aggregationFns) },
  // other options...
  state: {
    grouping,
  },
  onGroupingChange: setGrouping,
})

Grouping APIs#

Columns expose grouping APIs for toggling grouping and building grouping UI:

column.toggleGrouping()
column.getToggleGroupingHandler()
column.getCanGroup()
column.getIsGrouped()
column.getGroupedIndex()
column.getAutoAggregationFn()
column.getAggregationFn()

column.toggleGrouping()
column.getToggleGroupingHandler()
column.getCanGroup()
column.getIsGrouped()
column.getGroupedIndex()
column.getAutoAggregationFn()
column.getAggregationFn()

Rows expose grouping helpers for grouped row rendering:

row.getIsGrouped()
row.getGroupingValue(columnId)
row.groupingColumnId
row.groupingValue

row.getIsGrouped()
row.getGroupingValue(columnId)
row.groupingColumnId
row.groupingValue

Cells expose helpers for choosing between grouped, aggregated, placeholder, and normal cell rendering:

cell.getIsGrouped()
cell.getIsAggregated()
cell.getIsPlaceholder()

cell.getIsGrouped()
cell.getIsAggregated()
cell.getIsPlaceholder()

The table instance exposes grouped and pre-grouped row models:

table.getGroupedRowModel()
table.getPreGroupedRowModel()

table.getGroupedRowModel()
table.getPreGroupedRowModel()

Use table.setGrouping and table.resetGrouping to update the grouping state directly.