AdaptTable for Ant Design

Aggregation in Ant Design

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 Ant Design's own table rows. Building and reordering group levels stays on the grouping page.

Group totals splice into antd's dataSource the same way group headers do; the footer is antd's Table.Summary, and pinned summaries are extra records the adapter marks.

The code

import { aggregate } from "@adapttable/core";
import { DataTable } from "@adapttable/antd";
import { groupingPanel } from "@adapttable/antd/grouping-panel";
import { pinnedSummaryRows } from "@adapttable/antd/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/antd @adapttable/core antd

The same feature in the other kits

More Ant Design features

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