IPivotTableConfig

IPivotTableConfig.columnHeadersPositionpropertyAlpha

Alpha API. Initial API, highly likely to change outside SemVer. Don’t build on it in production. See API maturity.

Customize placement of column headers - top or left

Default: “top”

columnHeadersPosition?: ColumnHeadersPosition;

IPivotTableConfig.columnSizingproperty

Customize column sizing strategy.

columnSizing?: IColumnSizing;

Remarks

Default: none

IPivotTableConfig.enableExecutionCancellingproperty

Enable execution cancelling.

enableExecutionCancelling?: boolean;

Remarks

Default: false

IPivotTableConfig.grandTotalsPositionproperty

Customize position of grand totals rows in the table.

grandTotalsPosition?: GrandTotalsPosition;

Remarks

• “pinnedBottom” - Grand totals are pinned at the bottom (always visible while scrolling) - “pinnedTop” - Grand totals are pinned at the top (always visible while scrolling) - “bottom” - Grand totals appear at the end of the table data (scrolls with content) - “top” - Grand totals appear at the beginning of the table data (scrolls with content)

Default: “pinnedBottom”

IPivotTableConfig.groupRowsproperty

Specify whether the table should group rows.

groupRows?: boolean;

Remarks

If this is turned on and the table is sorted by the first row attribute, then the grouping will take effect.

Default: true

IPivotTableConfig.maxHeightproperty

Customize maximum height of the table.

maxHeight?: number;

IPivotTableConfig.measureGroupDimensionpropertyAlpha

Alpha API. Initial API, highly likely to change outside SemVer. Don’t build on it in production. See API maturity.

Customize placement of metrics - in columns or in rows

Default: “columns”

measureGroupDimension?: MeasureGroupDimension;

IPivotTableConfig.menuproperty

customize whether the column-level burger menu should be visible and if so, what aggregations should be allowed.

menu?: IMenu;

IPivotTableConfig.separatorsproperty

Customize number segment separators (thousands, decimals)

separators?: ISeparators;