> Documentation index: https://www.gooddata.ai/docs/gooddata-ui/llms.txt lists every page of these docs as Markdown.

# IPivotTableConfig

- Package: [@gooddata/sdk-ui-pivot](https://www.gooddata.ai/docs/gooddata-ui/latest/api-reference/sdk-ui-pivot/index.md)
- Kind: interface
- Source: https://github.com/gooddata/gooddata-ui-sdk/blob/rel/11.64/libs/sdk-ui-pivot/src/publicTypes.ts

**Signature:**

```typescript
export interface IPivotTableConfig 
```

## Properties

| Property | Modifiers | Type | Description |
| --- | --- | --- | --- |
| [columnHeadersPosition?](https://www.gooddata.ai/docs/gooddata-ui/latest/api-reference/sdk-ui-pivot/sdk-ui-pivot.ipivottableconfig/index.md#ipivottableconfigcolumnheadersposition) |  | [ColumnHeadersPosition](https://www.gooddata.ai/docs/gooddata-ui/latest/api-reference/sdk-ui-pivot/sdk-ui-pivot.columnheadersposition/index.md) | **_(ALPHA)_** _(Optional)_ Customize placement of column headers - top or left Default: "top" |
| [columnSizing?](https://www.gooddata.ai/docs/gooddata-ui/latest/api-reference/sdk-ui-pivot/sdk-ui-pivot.ipivottableconfig/index.md#ipivottableconfigcolumnsizing) |  | [IColumnSizing](https://www.gooddata.ai/docs/gooddata-ui/latest/api-reference/sdk-ui-pivot/sdk-ui-pivot.icolumnsizing/index.md) | _(Optional)_ Customize column sizing strategy. |
| [enableExecutionCancelling?](https://www.gooddata.ai/docs/gooddata-ui/latest/api-reference/sdk-ui-pivot/sdk-ui-pivot.ipivottableconfig/index.md#ipivottableconfigenableexecutioncancelling) |  | boolean | _(Optional)_ Enable execution cancelling. |
| [grandTotalsPosition?](https://www.gooddata.ai/docs/gooddata-ui/latest/api-reference/sdk-ui-pivot/sdk-ui-pivot.ipivottableconfig/index.md#ipivottableconfiggrandtotalsposition) |  | [GrandTotalsPosition](https://www.gooddata.ai/docs/gooddata-ui/latest/api-reference/sdk-ui-pivot/sdk-ui-pivot.grandtotalsposition/index.md) | _(Optional)_ Customize position of grand totals rows in the table. |
| [groupRows?](https://www.gooddata.ai/docs/gooddata-ui/latest/api-reference/sdk-ui-pivot/sdk-ui-pivot.ipivottableconfig/index.md#ipivottableconfiggrouprows) |  | boolean | _(Optional)_ Specify whether the table should group rows. |
| [maxHeight?](https://www.gooddata.ai/docs/gooddata-ui/latest/api-reference/sdk-ui-pivot/sdk-ui-pivot.ipivottableconfig/index.md#ipivottableconfigmaxheight) |  | number | _(Optional)_ Customize maximum height of the table. |
| [measureGroupDimension?](https://www.gooddata.ai/docs/gooddata-ui/latest/api-reference/sdk-ui-pivot/sdk-ui-pivot.ipivottableconfig/index.md#ipivottableconfigmeasuregroupdimension) |  | [MeasureGroupDimension](https://www.gooddata.ai/docs/gooddata-ui/latest/api-reference/sdk-ui-pivot/sdk-ui-pivot.measuregroupdimension/index.md) | **_(ALPHA)_** _(Optional)_ Customize placement of metrics - in columns or in rows Default: "columns" |
| [menu?](https://www.gooddata.ai/docs/gooddata-ui/latest/api-reference/sdk-ui-pivot/sdk-ui-pivot.ipivottableconfig/index.md#ipivottableconfigmenu) |  | [IMenu](https://www.gooddata.ai/docs/gooddata-ui/latest/api-reference/sdk-ui-pivot/sdk-ui-pivot.imenu/index.md) | _(Optional)_ customize whether the column-level burger menu should be visible and if so, what aggregations should be allowed. |
| [separators?](https://www.gooddata.ai/docs/gooddata-ui/latest/api-reference/sdk-ui-pivot/sdk-ui-pivot.ipivottableconfig/index.md#ipivottableconfigseparators) |  | [ISeparators](https://www.gooddata.ai/docs/gooddata-ui/latest/api-reference/sdk-model/sdk-model.iseparators/index.md) | _(Optional)_ Customize number segment separators (thousands, decimals) |

## Property details

### IPivotTableConfig.columnHeadersPosition

> **Alpha API.** Initial API, highly likely to change outside SemVer. Don't build on it in production. See [API maturity](https://www.gooddata.ai/docs/gooddata-ui/latest/integrations/platform/api-maturity/index.md).
> 

Customize placement of column headers - top or left

Default: "top"

**Signature:**

```typescript
columnHeadersPosition?: ColumnHeadersPosition;
```

### IPivotTableConfig.columnSizing

Customize column sizing strategy.

**Signature:**

```typescript
columnSizing?: IColumnSizing;
```

#### Remarks

Default: none

### IPivotTableConfig.enableExecutionCancelling

Enable execution cancelling.

**Signature:**

```typescript
enableExecutionCancelling?: boolean;
```

#### Remarks

Default: false

### IPivotTableConfig.grandTotalsPosition

Customize position of grand totals rows in the table.

**Signature:**

```typescript
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.groupRows

Specify whether the table should group rows.

**Signature:**

```typescript
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.maxHeight

Customize maximum height of the table.

**Signature:**

```typescript
maxHeight?: number;
```

### IPivotTableConfig.measureGroupDimension

> **Alpha API.** Initial API, highly likely to change outside SemVer. Don't build on it in production. See [API maturity](https://www.gooddata.ai/docs/gooddata-ui/latest/integrations/platform/api-maturity/index.md).
> 

Customize placement of metrics - in columns or in rows

Default: "columns"

**Signature:**

```typescript
measureGroupDimension?: MeasureGroupDimension;
```

### IPivotTableConfig.menu

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

**Signature:**

```typescript
menu?: IMenu;
```

### IPivotTableConfig.separators

Customize number segment separators (thousands, decimals)

**Signature:**

```typescript
separators?: ISeparators;
```