AdaptTable for Spartan

Aggregation in Spartan

aggregate() computes the table footer and each team's groupAggregates; groupFooters closes each team with its subtotal.

Search the table and group totals and the footer recompute from matching rows. The host-owned portfolio total uses pinnedSummaryRows and remains above the scrolling body, independent of filtering and sorting.

All three surfaces render through the same Spartan controls on desktop and in phone cards.

The code

import { Component, computed, input } from "@angular/core";
import { aggregate, type ColumnDef } from "@adapttable/angular";
import { AdaptDataTable } from "@adapttable/spartan";
import { groupingPanel } from "@adapttable/spartan/grouping-panel";
import { pinnedSummaryRows } from "@adapttable/spartan/pinned-summary-rows";

@Component({
  selector: "app-totals",
  imports: [AdaptDataTable],
  template: `
    <adapt-data-table
      [data]="rows()" [columns]="columns" [rowKey]="rowKey"
      [summaryRow]="budgetSum" [features]="features()"
    />
  `,
})
export class Totals {
  readonly rows = input.required<readonly Person[]>();
  readonly totals = input.required<readonly Person[]>();
  readonly columns: ColumnDef<Person>[] = [
    { key: "name" }, { key: "team" }, { key: "budget" },
  ];
  readonly rowKey = (row: Person) => row.id;
  readonly budgetSum = aggregate<Person>({ budget: "sum" });
  readonly features = computed(() => [
    groupingPanel<Person>("team", {
      groupAggregates: this.budgetSum, groupFooters: true,
    }),
    pinnedSummaryRows<Person>({ top: this.totals() }),
  ]);
}

Install

# Follow the kit setup guide for compatible peers
pnpm add @adapttable/spartan @adapttable/angular @spartan-ng/brain@1.5.0 @angular/cdk@^22 @angular/forms@^22 rxjs@^7.8.0 tailwindcss@^4 clsx@^2.1.1 tw-animate-css@^1

The same feature in the other kits

• Aggregation in Unstyled — Native elements — your own CSS
• Aggregation in NG-ZORRO — Ant Design components for Angular
• Aggregation in Angular Material — Material surfaces, native controls
• Aggregation in ng-bootstrap — Bootstrap styling, Angular overlays
• Aggregation in Angular Aria — Accessible behavior, precise styling
• Aggregation in ngx-bootstrap — Bootstrap controls and overlays
• Aggregation in Angular CDK — CDK behavior, a neutral theme
• Aggregation in Taiga UI — Soft surfaces, expressive controls

More Spartan features

• Filtering in Spartan — Ranges, selects, an AND/OR tree and chips — all in the URL.
• Column management in Spartan — Show, hide, reorder, pin and resize — from a menu you did not write.
• Column groups in Spartan — Spanning headers that collapse to a stub, a kept child, or a custom cell.
• Row selection in Spartan — A set of ids that survives paging, with bulk actions over it.
• Rows in Spartan — Pin rows from a 3-dot menu, and merge a team that runs down the page.
• Row reordering in Spartan — Drag or keyboard moves, announced — the host writes.
• Inline cell editing in Spartan — Native editors in the cell; every write goes through your handler.
• Row grouping in Spartan — Drag, select or keyboard grouping, with totals in the headers.
• Nested tables in Spartan — A real table under a row — same engine, own columns, own keys.
• CSV export in Spartan — One toolbar button, a CSV of the table as it stands.
• Row and column virtualization in Spartan — 40,000 rows in a scroll box, only the visible ones rendered.
• Tree data in Spartan — Nesting, chevrons, lazy children, and a tree on phones.
• Mobile cards in Spartan — Every row becomes a card on phones. Automatically, with the same state.
• Pivot tables in Spartan — Rows down the side, dimensions across the top, subtotals at every level.
• Saved views in Spartan — Name an arrangement and restore it from the menu.
• Spreadsheet formulas in Spartan — ROUND, POWER, SQRT, IF — computed columns, errors in the cell.
• Right-to-left Spartan data table — Arabic strings, a flipped axis, and a popover that opens from the right edge.
• Live updates in Spartan — Rows change while you read them. Sort and selection hold.
• Accessible Spartan data table — Arrow-key focus, a visible ring, forced-colors, and live announcements.
• AI table assistant in Spartan Angular — Local sort, questions and approved edits with real table outcomes.

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