ColumnPivotColumnItem
Configuration for the column dimension of a pivot.
Each item defines a field whose values will be used to generate dynamic columns in the pivot view.
active
propertyDetermines whether this column pivot is currently active.
Defaults to true .
Type
boolean
field
propertyThe column id used to generate pivoted columns.
Type
string
ColumnPivotModel
The full configuration model for column pivoting in LyteNyte Grid.
This includes row grouping, column generation, value aggregation, and sort/filter configuration for the pivoted result.
columns
propertyFields to pivot on for generating dynamic columns. See ColumnPivotColumnItem .
No properties
filters
propertyFilter configuration for the pivot view.
Like the sort model, filters apply to the dynamically generated pivot columns.
| Type | Record |
filtersIn
propertyIn Filter configuration for the pivot view.
Like the sort model, in filters apply to the dynamically generated pivot columns.
| Type | Record |
rows
propertyRow-level groupings for the pivot. See ColumnPivotRowItem .
No properties
sorts
propertySort configuration for the pivot result view.
The sort keys must match dynamically generated pivot column ids.
No properties
values
propertyThe value items (measures) to compute and display in the pivot result.
Each value is aggregated for every dynamic column combination created by the pivot. See ColumnPivotValueItem .
No properties
ColumnPivotRowItem
Configuration for row-level grouping in a column pivot model.
These items define which fields should be used to group rows before creating pivot columns.
active
propertyIndicates whether this grouping is active.
Defaults to true . Set to false to temporarily disable this row grouping without removing it.
Type
boolean
field
propertyThe column id to group rows by.
Type
string
ColumnPivotValueItem
Configuration for value fields in a pivot (also known as measures).
These values define what numeric or aggregate data should be shown for each cell in the pivot result.
active
propertyIndicates whether this value item is enabled.
Defaults to true . Set to false to exclude this value from the pivot result.
Type
boolean
aggFn
propertyThe aggregation function to apply to the value. See AggModelFn .
| Type | AggModelFn |
field
propertyThe column id representing the value to aggregate.
Type
string