Grouping & Aggregates
Enable multi-level column grouping by turning on groupable. Use the aggregate property on the column schema to automatically tally values for groups inside group footers.
Name
Role
City
Salary
Bonus
Employee 001
User
Delhi
₹1,80,000
₹21,000
Employee 002
Editor
Bangalore
₹41,000
₹27,000
Employee 003
Manager
Chennai
₹1,89,000
₹12,000
Employee 004
Viewer
Hyderabad
₹1,32,000
₹17,000
Employee 005
Admin
Mumbai
₹89,000
₹10,000
Employee 006
User
Delhi
₹1,57,000
₹8,000
Employee 007
Editor
Bangalore
₹1,63,000
₹23,000
Employee 008
Manager
Chennai
₹1,57,000
₹8,000
Employee 009
Viewer
Hyderabad
₹1,84,000
₹18,000
Employee 010
Admin
Mumbai
₹57,000
₹30,000
Employee 011
User
Delhi
₹1,18,000
₹15,000
Employee 012
Editor
Bangalore
₹1,31,000
₹6,000
Employee 013
Manager
Chennai
₹1,20,000
₹16,000
Employee 014
Viewer
Hyderabad
₹1,38,000
₹8,000
Employee 015
Admin
Mumbai
₹1,67,000
₹7,000
Employee 016
User
Delhi
₹1,36,000
₹17,000
Employee 017
Editor
Bangalore
₹81,000
₹0
Employee 018
Manager
Chennai
₹1,95,000
₹20,000
Employee 019
Viewer
Hyderabad
₹1,36,000
₹20,000
Employee 020
Admin
Mumbai
₹64,000
₹0
Employee 021
User
Delhi
₹44,000
₹30,000
Employee 022
Editor
Bangalore
₹1,25,000
₹28,000
Employee 023
Manager
Chennai
₹78,000
₹0
Employee 024
Viewer
Hyderabad
₹1,51,000
₹26,000
Employee 025
Admin
Mumbai
₹86,000
₹0
Employee 026
User
Delhi
₹1,99,000
₹19,000
Employee 027
Editor
Bangalore
₹72,000
₹1,000
Employee 028
Manager
Chennai
₹1,84,000
₹8,000
Employee 029
Viewer
Hyderabad
₹1,20,000
₹22,000
Employee 030
Admin
Mumbai
₹1,81,000
₹24,000
30 Records
tsx
1import { useMemo } from "react";2import { DataGrid, GridColumn } from "@quartix/grid";3import { MEDIUM_DATA } from "@/data";45export default function GroupingExample() {6 const columns = useMemo<GridColumn[]>(7 () => [8 { key: "name", header: "Name", flex: 1 },9 { key: "department", header: "Department", width: 140 },10 { key: "role", header: "Role", width: 120 },11 {12 key: "salary",13 header: "Salary",14 width: 140,15 aggregate: "sum",16 footer_aggregate: "sum",17 },18 ],19 []20 );2122 return (23 <DataGrid24 data={MEDIUM_DATA}25 columns={columns}26 height={400}27 groupable28 showGroupExpandControls29 groupBarVisibility="visible"30 groupFooterVariant="chips"31 />32 );33}