Documentation

@kanunilabs/pivotgrid-enterprise


@kanunilabs/pivotgrid-enterprise / PivotAiState

Interface: PivotAiState

The pivot's layout in the schema's shape; a part left out is left as it is.

Properties

columns?

optional columns?: string[]

Column dimensions, outermost first.


filters?

optional filters?: PivotAiFilter[]

Every value filter; [] clears them.


rows?

optional rows?: string[]

Row dimensions, outermost first.


sort?

optional sort?: PivotAiSort[]

Every dimension sort; a dimension not listed keeps its data order.


totals?

optional totals?: PivotAiTotals


values?

optional values?: PivotAiValue[]

Measures in the cells.