AdaptTable for Chakra

Pivot tables in Chakra

Grouping answers “what is the total per team”. A pivot answers “what is the total per team per status”, and that second dimension becomes columns your data never had.

Fields move between the three zones with buttons rather than drag, so the pivot can be built from the keyboard. Subtotals close every group and a grand total closes the table.

The configuration — axes, measures, aggregation and what you folded — lives in the URL, so a pivot you build is a pivot you can send someone.

Each zone is a Stack rendered as a fieldset with a Text legend — Chakra's reset strips the browser's own frame, so the border is the kit's — and the moves are xs outline Buttons beside NativeSelect pickers.

The code

import { DataTable, PivotPanel } from "@adapttable/chakra";
import {
  pivot,
  pivotTableModel,
  usePivotUrlState,
} from "@adapttable/react/pivot";

export function Spend({ rows, fields }) {
  const { config, onConfigChange, collapsed } = usePivotUrlState({
    urlKey: "p",
    defaultConfig: {
      rows: ["team"],
      columns: ["status"],
      measures: [{ key: "budget", agg: "sum" }],
    },
  });
  const model = pivotTableModel(pivot(rows, config, { collapsed }), {
    fields,
  });
  return (
    <>
      <PivotPanel fields={fields} config={config} onChange={onConfigChange} />
      <DataTable
        data={model.rows}
        columns={model.columns}
        rowKey={model.rowKey}
        summaryRow={model.summaryRow}
      />
    </>
  );
}

Install

pnpm add @adapttable/chakra @adapttable/core @chakra-ui/react @emotion/react

The same feature in the other kits

• Pivot tables in Mantine — Rounded, friendly, filled controls
• Pivot tables in MUI — Material elevation, uppercase actions
• Pivot tables in Ant Design — Compact, tinted header, crisp
• Pivot tables in Radix — Radix Themes, iris accent
• Pivot tables in Base UI — Unstyled primitives, blue accent
• Pivot tables in shadcn — Monochrome, ring focus
• Pivot tables in Tailwind — Unstyled — your own classes

More Chakra features

• Filtering in Chakra — Operators, an AND/OR tree, chips, and find in the same URL.
• Column management in Chakra — Show, hide, reorder, pin and resize — from a menu you did not write.
• Column groups in Chakra — Spanning headers that collapse to a stub, a kept child, or a custom cell.
• Row selection in Chakra — A set of ids that survives paging, with bulk actions over it.
• Rows in Chakra — Pin rows, merge cells, and a 3-dot menu for add and delete.
• Row reordering in Chakra — Flat, grouped and tree moves — keyboard, confirm, host writes.
• Inline cell editing in Chakra — Kit-native editors in the cell; every write goes through your handler.
• Row grouping in Chakra — Drag, keyboard and mobile grouping controls with live aggregation overrides.
• Aggregation in Chakra — Footer totals, pinned summaries, group aggregates — not data rows.
• Nested tables in Chakra — A real table under a row — same engine, own columns, own keys.
• Export and print in Chakra — Browser files or cancellable server jobs — CSV, XLSX and PDF.
• Row and column virtualization in Chakra — 100k rows, 40 columns, virtualized rows and columns, sticky chrome.
• Tree data in Chakra — Nesting, chevrons, URL expansion, and host-owned tree moves.
• Mobile cards in Chakra — Every row becomes a card on phones. Automatically, with the same state.
• Saved views in Chakra — Name an arrangement, share it as a link, manage the list in place.
• Spreadsheet formulas in Chakra — ROUND, POWER, SQRT, IF — computed columns, errors in the cell.
• Right-to-left Chakra data table — Arabic strings, a flipped axis, and a popover that opens from the right edge.
• Live updates in Chakra — Rows change while you read them. Sort and selection hold.
• Accessible Chakra data table — Arrow-key focus, a visible ring, forced-colors, and live announcements.
• AI table assistant in Chakra — Native assistant, feature-aware prompts and governed action receipts.

Reference: pivot. More of this kit: AdaptTable for Chakra, or the live demo.