AdaptTable for Tailwind

Pivot tables in Tailwind

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.

The pivot panel takes no class map at all, so its fieldset, legend, selects and buttons are browser defaults — the table below is fully styled, and the zone editor is yours to dress.

The code

import { DataTable, PivotPanel } from "@adapttable/unstyled";
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/unstyled @adapttable/core

The same feature in the other kits

More Tailwind features

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