pivot would generate {n} columns, above the limit of {max}. Pivot on a lower-cardinality column, or raise pivot.maxColumns.

Warnings reference › pivot.maxColumns:*

Identifier

pivot.maxColumns:*

Raised by

The grid (core)

Since

1.0.1

What happened

The pivot was refused before any columns were built: the number of value columns times the number of distinct pivot values exceeds the limit. No pivot columns are generated and the refusal is returned as the pivot's error, so the grid shows its unpivoted self rather than tens of thousands of columns.

The fix

Pivot on a column with fewer distinct values, narrow the rows with a filter first, or raise pivot.maxColumns deliberately.

The smallest fix

createGrid(el, { pivot: { maxColumns: 500 } });

Reference

Covered in full at the API reference.