The grid (core) ยท console.warn
column "{id}" cannot be pivoted: a secret co...
Printed by The grid (core), prefixed [lattice], since 1.126.0.
Warnings reference › pivot.secret:*
- Identifier
pivot.secret:*- Raised by
- The grid (core)
- Since
- 1.126.0
What happened
A secret column was named in columns.pivot(). Each distinct value becomes a pivot heading - the raw value, not the mask - so the column is left out of the pivot rather than expose its hidden values.
The fix
Pivot on a different column, or do not pivot this column.
The smallest fix
grid.columns.pivot('category'); // not the secret column
Reference
Covered in full at the API reference.