AdaptTable for Base UI

Aggregation in Base UI

A summary row is not a pinned data row and not a group footer. summaryRow writes a grand total in the table footer. pinnedSummaryRows sticks host-owned totals above or below the scroll box. groupAggregates plus groupFooters close each group.

Filter the table and every total recomputes from the rows that remain — client aggregate() and a source that already computed the same numbers share one mapper shape. Extra full-width rows stay attached to a person, not to a total.

The footer, the pinned summaries and the group totals render through Base UI's own table rows. Building and reordering group levels stays on the grouping page.

Totals render as Base UI table rows; the pinned pair uses the adapter's sticky classes rather than a portal, so they stay in the scroll box.

The code

import { aggregate } from "@adapttable/core";
import { DataTable } from "@adapttable/base-ui";
import { groupingPanel } from "@adapttable/base-ui/grouping-panel";
import { pinnedSummaryRows } from "@adapttable/base-ui/pinned-summary-rows";

export function Sales({ rows, columns }) {
  const budgetSum = aggregate({ budget: "sum" }, { columns });
  return (
    <DataTable
      data={rows}
      columns={columns}
      rowKey={(row) => row.id}
      summaryRow={budgetSum}
      features={[
        groupingPanel(["team"], {
          groupAggregates: budgetSum,
          groupFooters: true,
        }),
        pinnedSummaryRows({
          top: [{ id: "team-total", name: "Team total" }],
          bottom: [{ id: "grand-total", name: "Grand total" }],
        }),
      ]}
    />
  );
}

Install

pnpm add @adapttable/base-ui @adapttable/core @base-ui/react

The same feature in the other kits

More Base UI features

Reference: row-grouping, pinned-summary-rows, full-width-rows. More of this kit: AdaptTable for Base UI, or the live demo.