@univerjs-pro/sheets-pivot

!CSS Included
!i18n

Introduction

A pivot table is a powerful data analysis tool used for quickly and dynamically summarizing and analyzing large volumes of data. It allows users to group, filter, sort, and aggregate raw data across different dimensions, revealing patterns and trends within the data. By dragging and dropping fields to define rows, columns, and values, users can create cross-tabulated tables for multi-level data summarization. Common functions include sum, count, average, maximum/minimum, and more, enabling users to derive valuable insights from complex data. Pivot tables are ideal for scenarios such as financial analysis, business monitoring, and sales data reporting.

Usage

$3

``shell


Using npm

npm install @univerjs-pro/sheets-pivot-ui @univerjs-pro/sheets-pivot

Using pnpm

pnpm add @univerjs-pro/sheets-pivot-ui @univerjs-pro/sheets-pivot
`

$3

`ts
import { UniverSheetsPivotTablePlugin } from '@univerjs-pro/sheets-pivot';
import { UniverSheetsPivotTableUIPlugin } from '@univerjs-pro/sheets-pivot-ui';

univer.registerPlugin(UniverSheetsPivotTablePlugin);
univer.registerPlugin(UniverSheetsPivotTableUIPlugin);
``