Grouping
Grouping lets you organize your table into expandable sections based on one or more columns, creating a hierarchical view of your data.
How it works
You can group by a single column or combine multiple levels of grouping. For example:
- Group by Region
- Then by Manager
- Then by Product
This creates a nested, expandable structure that helps you explore patterns and relationships in your data.
Grouping and aggregation
When grouping is enabled, you can define how each column behaves using aggregation functions such as: Sum, Average, Min, Max, Count, or Count distinct.
Configure these from the Columns section .
Aggregated values are displayed in the group row, summarizing all rows inside that group.
Example
If you group by Date and apply a Sum aggregation on the Total column, each group row will show the total value for that date.
This allows you to quickly understand totals without expanding each group.
Behavior details
- Grouped rows can be expanded or collapsed.
- Only grouped or aggregated columns are shown in summary rows.
- Non-aggregated columns are hidden in group rows to avoid misleading values.
Important: Grouping must be enabled from the Display tab. Aggregation is configured separately per column in the Columns tab.
Want to try it in your site? InstallSimple Tables for Confluence from the Atlassian Marketplace.