AdaptTable for NG-ZORRO

Pivot tables in NG-ZORRO

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 code

import { Component, computed, input } from "@angular/core";
import { AdaptDataTable } from "@adapttable/ng-zorro";
import {
  AdaptPivotPanel, injectPivotUrlState, pivot, pivotTableModel,
  type PivotField,
} from "@adapttable/ng-zorro/pivot";

@Component({
  selector: "app-spend",
  imports: [AdaptDataTable, AdaptPivotPanel],
  template: `
    <adapt-pivot-panel
      [fields]="fields" [config]="state.config()"
      [onChange]="state.onConfigChange"
    />
    <adapt-data-table
      [data]="model().rows" [columns]="model().columns"
      [rowKey]="model().rowKey" [summaryRow]="model().summaryRow"
    />
  `,
})
export class Spend {
  readonly rows = input.required<readonly Person[]>();
  readonly fields: readonly PivotField[] = [
    { key: "team", label: "Team" }, { key: "status", label: "Status" },
    { key: "budget", label: "Budget" },
  ];
  readonly state = injectPivotUrlState({
    urlKey: "p",
    defaultConfig: {
      rows: ["team"], columns: ["status"],
      measures: [{ key: "budget", agg: "sum" }],
    },
  });
  readonly model = computed(() => pivotTableModel(
    pivot(this.rows(), this.state.config(), { collapsed: this.state.collapsed() }),
    { fields: this.fields },
  ));
}

Install

pnpm add @adapttable/ng-zorro @adapttable/angular @adapttable/core ng-zorro-antd @angular/forms @angular/router

The same feature in the other kits

• Pivot tables in Unstyled — Native elements — your own CSS
• Pivot tables in Angular Material — Material surfaces, native controls
• Pivot tables in ng-bootstrap — Bootstrap styling, Angular overlays
• Pivot tables in Angular Aria — Accessible behavior, precise styling
• Pivot tables in ngx-bootstrap — Bootstrap controls and overlays
• Pivot tables in Angular CDK — CDK behavior, a neutral theme
• Pivot tables in Spartan — Sharp borders, subtle elevation
• Pivot tables in Taiga UI — Soft surfaces, expressive controls

More NG-ZORRO features

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

Reference: pivot. More of this kit: AdaptTable for NG-ZORRO, or the live demo.