pivot_grid

A pivot. Type is pivot_grid.

Block	What it is
`Pivot`	Native config for dxPivotGrid
`Chart`	Native config for dxChart
`Component`	Platform keys. They all live here
`Toolbar`	Toolbar
`Title`	Title

Keys inside Pivot and Chart stay lowercase. ChartPanel.bindOptions and DrillDown.columns are native parameters too, so they stay lowercase.

Component

Key	Meaning
`AutoLoad`	Load as soon as the page opens. On by default
`LoadSql`	SQL for the pivot data
`ReadOnly`	Read-only
`Title`	Component title
`PivotTune`	Pivot field tuning
`SwapAxes`	`{ Enabled }`. The toolbar swaps row fields and column fields, including expand paths

The chart sits beside or below the pivot.

Key	Meaning
`Visible`	Whether the chart is shown
`Position`	`bottom`, or a side
`Height`	Chart height
`WidthRatio`	Chart width as a fraction of the row
`WidthPx`	Chart width in pixels. Use this or the ratio
`SeriesType`	Series type, for example `bar`
`ChartTypes`	Chart types the user can pick
`Tune`	Finer chart settings
`SwapAxes`	`{ Enabled }`. Swap only the chart axes or series. The pivot fields stay

Double-click a total cell to open the detail rows.

Key	Meaning
`Enabled`	Whether drill-down is allowed
`Trigger`	`click` or `dblclick`
`MaxRows`	Maximum detail rows. `0` means do not truncate
`PopupWidth` / `PopupHeight`	Popup size
`columns`	Columns of the detail grid. Lowercase. A dxDataGrid column config

Edit numbers in the drilled-down detail, then write them back.

Key	Meaning
`Enabled`	Whether write-back is allowed
`KeyField`	Primary key of a detail row. Default `id`
`UpdateRowSql`	Update one row
`InsertRowSql`	Insert one row
`AllowInsertOnEmpty`	Allow an insert when no existing row was hit

Highlight the chart when the pivot is clicked.

Key	Meaning
`Enabled`	Whether the chart follows the pivot
`RangeSelect`	Allow dragging a selection on the data area