Lattice Grid

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.