# @univerjs-pro/sheets-pivot

- Human documentation: [https://docs.univer.ai/reference/packages/plugins/univerjs-pro/sheets-pivot](https://docs.univer.ai/reference/packages/plugins/univerjs-pro/sheets-pivot)

- Agent Markdown: [https://docs.univer.ai/reference/packages/plugins/univerjs-pro/sheets-pivot.md](https://docs.univer.ai/reference/packages/plugins/univerjs-pro/sheets-pivot.md)

- Requested language: `en-US`

- Content language: `en-US`

- Documentation version: `1.0.0-rc.0`

- Source: [packages/plugins/univerjs-pro/sheets-pivot.mdx](https://github.com/dream-num/documentation/blob/dev/content/reference/packages/plugins/univerjs-pro/sheets-pivot.mdx)

---

Pivot table integration for Univer Sheets.

```typescript
// [!code word:UniverSheetsPivotTablePlugin]
// [!code word:IUniverSheetsPivotConfig]
import { UniverSheetsPivotTablePlugin } from '@univerjs-pro/sheets-pivot'

univer.registerPlugin(UniverSheetsPivotTablePlugin, IUniverSheetsPivotConfig)
```

## Entry Points

* Facade: `@univerjs-pro/sheets-pivot/facade`
* Locale: `@univerjs-pro/sheets-pivot/locale/*`

## IUniverSheetsPivotConfig

```ts
export interface IUniverSheetsPivotConfig {
  notExecuteFormula?: boolean
  // When the user configures this property,
  // if there are cells containing data in the pivot table next view range,
  // they will be directly overwritten without popping up a dialog box for the user to select.
  defaultOverride?: boolean

  /**
   * Define the maximum number of items that can be displayed in a single pivot table field. The default value is 1000.
   */
  maxLimitItemCount?: number
}
```