Pivot table
The canonical pivot — service line grouped by performance vs service rows; suburbs grouped by northern vs southern Illawarra columns. Swap the active measure (revenue, jobs, parts margin) via the radio picker. Subtotals + grand total are derived.
Production answer
Pivot table is a reusable Oak Flats Muffler Men UI primitive with documented states, accessibility expectations, theme behavior, and implementation evidence.
Primary CTAReview Pivot table states
Generative search brief
Pivot table: The canonical pivot — service line grouped by performance vs service rows; suburbs grouped by northern vs southern Illawarra columns. Swap the active measure (revenue, jobs, parts margin) via the radio picker. Subtotals + grand total are derived.
Pivot
Suburb x service line · Week 22 FY26
| Northern Illawarra | Southern Illawarra | Total | |||||
|---|---|---|---|---|---|---|---|
| Wollongong | Oak Flats | Albion Park | Shellharbour | Kiama | |||
| Performance | Manta sport install | $8.4K | $5.2K | $1.8K | $2.2K | $1K | $18.7K |
| Cat-back system | $4.9K | $3.1K | $940 | $1.8K | $560 | $11.3K | |
| Dyno tune | $2.4K | $1.3K | $420 | $980 | $320 | $5.4K | |
| Service | Exhaust replace | $2K | $1.6K | $540 | $1.3K | $380 | $5.8K |
| Muffler retrofit | $620 | $980 | $320 | $540 | $210 | $2.7K | |
| RWC inspection | $240 | $410 | $180 | $260 | $120 | $1.2K | |
| Grand total | $18.5K | $12.6K | $4.2K | $7.1K | $2.6K | $45.1K | |