AdaptTable for Radix

Pivot tables in Radix

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 Card wrapping a real fieldset — the fieldset is what a screen reader hears, the Card is what you see — with soft Buttons for the moves and Radix Selects for the pickers.

The code

import { DataTable, PivotPanel } from "@adapttable/radix";
import { usePivotUrlState } from "@adapttable/core/pivot";

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

Install

pnpm add @adapttable/radix @adapttable/core @radix-ui/themes

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 Chakra — Soft teal, generous radius
• Pivot tables in Ant Design — Compact, tinted header, crisp
• 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 Radix features

• Filtering in Radix — Kit-native operators, date ranges, checklists, an AND/OR tree, chips.
• Column management in Radix — Show, hide, reorder, pin and resize — from a menu you did not write.
• Column groups in Radix — Spanning headers that collapse to a stub, a kept child, or a custom cell.
• Row selection in Radix — A set of ids that survives paging, with bulk actions over it.
• Rows in Radix — Pin, drag-reorder, merge cells, and a 3-dot menu per row.
• Inline cell editing in Radix — Kit-native editors in the cell; every write goes through your handler.
• Row grouping in Radix — Nested group headers with counts, subtotals, footers and collapse state.
• Nested tables in Radix — A real table under a row — same engine, own columns, own keys.
• Export and print in Radix — CSV, XLSX and PDF from one seam — plus a real print layout.
• Large datasets in Radix — 100k rows, 40 columns, virtualized rows and columns, sticky chrome.
• Tree data in Radix — Rows that contain rows — nesting, chevrons, keyboard traversal.
• Mobile cards in Radix — Every row becomes a card on phones. Automatically, with the same state.
• Saved views in Radix — Name an arrangement, share it as a link, manage the list in place.
• Spreadsheet formulas in Radix — Computed columns typed as formulas, errors reported in the cell.
• Right-to-left Radix data table — Arabic strings, a flipped axis, and a popover that opens from the right edge.
• Live updates in Radix — Rows change while you read them. Sort and selection hold.
• Accessible Radix data table — Arrow-key focus, a visible ring, and every announcement shown as text.

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