Pivot
View sourceCross-tabulate any column against any other. Drag columns into the row, column, and value zones in the pivot tool panel; bc-grid renders the pivoted matrix with subtotals and grand totals.
Try this
The pivot tool panel is open in the right sidebar. The grid is pre-pivoted: Region → row, Status → column, sum(Amount) → value.
- Drag "Sales rep" from the columns list into the Row groups zone — now you have a two-level pivot.
- Drag "Amount" into the Values zone with a different aggregation (sum / avg / max).
- Drag a column out of a zone to remove it.
- Toggle the subtotals checkboxes — row subtotals, column subtotals, both.
Pivot state
- rowGroups. Columns whose distinct values become the rows of the pivot.
- colGroups. Columns whose distinct values become the columns of the pivot.
- values. The cells. Each entry is a
{ columnId, aggregation, label }— the sameBcAggregationshape used by the column footer. - subtotals.
{ rows?: boolean; cols?: boolean }. Both default totrue.
Where pivot belongs
- Reporting screens. Sales by region × month, AR by customer × invoice age, inventory by warehouse × category.
- Drill-down dashboards. Pair pivot with a saved-view picker so users restore named cross-tabs in one click.
- Composes with export. The pivoted shape exports to CSV / Excel as a normal matrix.