mates-grid

Pivot

Mark a column pivot: true and set pivotMode. Value columns are generated from distinct keys (years here) with the configured aggregations.

Region × year

Toggle pivot mode from the atom. Secondary value columns appear for each year.

Region

Amount (2022)

Amount (2023)

Amount (2024)

Qty (2022)

Qty (2023)

Qty (2024)

EMEA

$3,560

APAC

$3,672

Americas

$3,784

{ field: "year", pivot: true }
{ field: "amount", aggFunc: "sum" }

grid.setPivotMode(true);