Expand Column Groups

Column expansion lets users move from a summary header, such as Year, to the quarters or months underneath it. It is separate from row expansion.

Try the column hierarchy

Interactive example

Expand years into quarters

Expand a year or quarter to see its details; collapse it to compare summaries.

Try it: Use the year and quarter header controls to expand or collapse the time groups.

The example loads when visible.

Reset

What to notice: Expanded headers show more detail; collapsed headers make it easier to compare summaries.

Expand a generated column group and compare its total with the details. Collapsing a group changes what is displayed; its summary still represents its contributing records.

Column Drill-Down

Column drill-down is built into Pivot whenever columns is non-empty. Generated groups start collapsed without additional configuration.

columns: ['year', 'quarter', 'month']

Behavior:

• generated Pivot column groups become collapsible
• generated groups start collapsed at the highest level and expand one level at a time
• set columnCollapse: false or { enabled: false } to disable column drill-down
• set columnCollapse: { collapsed: false } to start with all generated groups expanded
• use columnLevels to override collapse, subtotal, filter, and sort behavior independently at each zero-based column level
• collapsed groups render a placeholder header/cell
• placeholder cells use a collapsed-bucket aggregator, not a naive sum of visible child cells
• expanded subtotal columns appear before descendant columns by default, keeping the parent aggregate visible and actionable
• columnLevels[level].subtotalValues can keep that aggregate to one value field—or any ordered subset—when the Pivot has multiple measures
• expanding reveals one level only; descendants and sibling branches keep their current state
• aggregate filters and sorting remain attached to the same analytical group when its compact and expanded presentations switch

Persisted state for generated groups lives in collapsedColumns.

See Column Totals With Drill-Down for the complete subtotal/collapse behavior matrix, precedence rules, and screenshots.

Next steps

Configure totals and subtotals, save expansion state, or explore chart drill-down.