Column Pivoting

Column pivoting transforms values from a column into new columns in your grid. Set the columnPivotModel property on grid state to enable this feature. Pivoting alone doesn't provide much value — you must also specify a measure column to calculate values in your pivot. Use the measureModel property to define which columns to use as measure functions.

LyteNyte Grid creates unique state for pivot columns with their own sort and filter settings and ordering.

Your underlying data source must support column pivoting. Since pivots derive from row values, creating columns from these values depends on your data source. Both the Client Row Data Source and Server Row Data Source support column pivoting.

Pivoting

To start column pivoting:

1. Set the columnPivotModel property to an array of column id strings. You can only use columns marked as columnPivotable.

2. Configure the measureModel with at least one measure function. Only columns with a measureFunc can appear in the measureModel.

3. Enable pivot mode by setting columnPivotModeIsOn to true in the grid state. This property toggles between normal mode and pivot mode.

TODO;

Pivots and Row Groups

LyteNyte Grid supports column pivots as a flattened view, where pivots break a measure into its constituent parts. Pivots and measures become most useful when combined with row groups. Simply set the rowGroupModel value on the grid state to enable this powerful combination.

TODO;

Column Pivot Field

Use the columnPivotField property on a column to determine the pivot value from row data. This helps with client-side pivoting and provides hints to other data sources on how to pivot columns.

TODO;

Measure Functions

Set the measureFunc property on a column to define how it behaves when added to the measureModel for pivots. Similar to Aggregations, columns have:

• A measureFuncDefault that sets the default function when added to the measure model
• A measureFuncsAllowed property that hints which functions a column may use for measuring

These properties help UI components guide users when selecting measures for columns.

TODO;

Column Pivots Programmatic Interface

Since most pivot column state is internal to the grid, LyteNyte Grid provides a comprehensive API for working with column pivots. Here are the key methods:

Sorting Column Pivots

Pivot columns use their own sort model, separate from normal columns. Access and modify this with:

• columnPivotSortModel: Retrieves the current pivot sort model
• columnPivotSetSortModel: Sets a new sort model for pivot columns

TODO;

Standard sort API methods like columnSortCycleToNext are pivot-mode aware and work on pivot columns.

Filtering Column Pivots

Access and modify pivot column filters with:

• columnPivotFilterModel: Retrieves the current filter model for pivot columns
• columnPivotSetFilterModel: Sets a new filter model for pivot columns

TODO;

Other Methods

These additional methods help with specific pivot operations:

• columnPivotsLoading: Returns true when pivot columns are loading asynchronously
• columnPivotsReload: Requests the grid to reload pivot columns from the data source
• columnPivotField: Returns the pivot key for a specific column and row
• columnPivotFieldFromData: Returns the pivot key for a specific column and data object
• columnPivotMeasureField: Returns the measure value for a specific column and data
• columnPivots: Returns all pivot columns
• columnIsPivot: Returns true if the specified column is a pivot column