@univerjs-pro/engine-pivot NPM

@univerjs-pro/engine-pivot

Introduction

Pivot table is a powerful data analysis tool that can quickly summarize, organize and analyze large amounts of data, thereby helping users discover patterns and trends in the data. This package contains the analyze logic for univer pivot.

11 subtotal methods supported like excel
Dimension label filtering and sorting (using localCompare method), label value filter.
tabular layout
expand / collapse
Supports multiple value dimensions, and can customize the area (value position) and position (value index) of the multi-value dimension.
rename field & format filed

More info you can get from link https://docs.univer.ai/en-US/guides/sheets/features/pivot-table/introduction#data-source

This npm package does not depend on any third-party libraries.

Usage

We do not recommend using this npm package alone because it is pure calculation logic without any UI. You can use @univerjs-pro/sheets-pivot and @univerjs-pro/sheets-pivot-ui to get the complete experience, here are the reference links: https://docs.univer.ai/en-US/guides/sheets/features/pivot-table

Installation

npm i @univerjs-pro/engine-pivot

Performance of Pivot Table

Test machine spec: a MacBook Pro with Apple Silicon M2 Pro.

Spreadsheet Cells Count	Read data (s)	Query time (s)
500k (1 pivot row dimension, 1 pivot col dimension, 2 value dimensions)	0.252	0.040
1M (1 pivot row dimension, 1 pivot col dimension, 2 value dimensions)	0.376	0.078
2M (1 pivot row dimension, 1 pivot col dimension, 2 value dimensions)	0.732	0.140
5M (1 pivot row dimension, 1 pivot col dimension, 2 value dimensions)	3.200	0.415

univer pivot table pivot table

jnpf-univer @univerjs-pro/facade @univerjs-pro/sheets-pivot @univerjs-pro/sheets-pivot-ui

0.6.6

4 months ago

0.6.5-nightly.202503121607

4 months ago

0.6.5

4 months ago

0.6.5-nightly.202503131607

4 months ago

0.6.6-nightly.202503151606

4 months ago

0.6.4-nightly.202503101606

4 months ago

0.6.4-nightly.202503111607

4 months ago

0.6.6-nightly.202503141606

4 months ago

0.6.3-nightly.202503071606

4 months ago

0.6.3-nightly.202503041606

4 months ago

0.6.3

4 months ago

0.6.4

4 months ago

0.6.3-nightly.202503061606

4 months ago

0.6.3-nightly.202503051607

4 months ago

0.6.2-nightly.202503031606

4 months ago

0.6.1-nightly.202502241606

4 months ago

0.6.1-nightly.202502231605

4 months ago

0.6.2

4 months ago

0.6.1-nightly.202502261607

4 months ago

0.6.1-nightly.202502251606

4 months ago

0.6.0-nightly.202502191606

4 months ago

0.6.0-experimental.20250220-d9a8e74

4 months ago

0.6.0-nightly.202502181606

4 months ago

0.6.1

4 months ago

0.6.1-nightly.202502221605

4 months ago

0.6.0-nightly.202502171606

4 months ago

0.6.0-nightly.202502201606

4 months ago

0.6.1-nightly.202502211606

4 months ago

0.6.0-nightly.202502091605

5 months ago

0.6.0-nightly.202502151605

4 months ago

0.6.0-nightly.202502101606

5 months ago

0.6.0-nightly.202502141606

5 months ago

0.6.0-nightly.202502111606

5 months ago

0.6.0

5 months ago

0.6.0-nightly.202502131606

5 months ago

0.6.0-experimental.20250212-dbe9830

5 months ago

0.6.0-nightly.202502121606

5 months ago

0.6.0-nightly.202502161605

4 months ago

0.5.5-nightly.202501231606

5 months ago

0.5.5-experimental.20250124-fc44c59

5 months ago

0.6.0-nightly.202501261605

5 months ago

0.6.0-nightly.202501251605

5 months ago

0.6.0-alpha.0

5 months ago

0.6.0-nightly.202502041606

5 months ago

0.6.0-nightly.202501311606

5 months ago

0.6.0-experimental.20250125-1d060b9

5 months ago

0.5.5-nightly.202501241606

5 months ago

0.5.5-nightly.202501221606

5 months ago

0.6.0-nightly.202501291606

5 months ago

0.6.0-nightly.202502061605

5 months ago

0.6.0-nightly.202502031606

5 months ago

0.6.0-nightly.202501301606

5 months ago

0.6.0-nightly.202501281606

5 months ago

0.6.0-nightly.202502071606

5 months ago

0.6.0-nightly.202502021605

5 months ago

0.6.0-nightly.202502081605

5 months ago

0.5.5-experimental.20250125-1aa33c0

5 months ago

0.5.5-experimental.20250123-34738ff

5 months ago

0.6.0-nightly.202501271606

5 months ago

0.6.0-nightly.202502051606

5 months ago

0.6.0-nightly.202502011605

5 months ago

0.5.5-nightly.202501220324

5 months ago

0.5.5-nightly.202501211606

5 months ago

0.5.4-nightly.202501191605

5 months ago

0.5.4-nightly.202501200849

5 months ago

0.5.5-nightly.202501210925

5 months ago

0.5.5-nightly.202501210404

5 months ago

0.5.5-experimental.20250122-3362a4a

5 months ago

0.5.5-nightly.202501201606

5 months ago

0.5.5-nightly.202501201336

5 months ago

0.5.5-nightly.202501210849

5 months ago

0.5.5

5 months ago

0.5.5-nightly.202501210604

5 months ago

0.5.5-nightly.202501210337

5 months ago

0.5.5-nightly.202501210734

5 months ago

0.5.4-nightly.202501171120

5 months ago

0.5.4-nightly.202501161606

5 months ago

0.5.4-nightly.202501141606

6 months ago

0.5.3-nightly.202501121605

6 months ago

0.5.4-nightly.202501160647

5 months ago

0.5.4-nightly.202501151252

6 months ago

0.5.4-nightly.202501170612

5 months ago

0.5.4-nightly.202501150735

6 months ago

0.5.4-experimental.20250114-7c09c35

6 months ago

0.5.4

6 months ago

0.5.4-nightly.202501181605

5 months ago

0.5.4-nightly.202501160704

5 months ago

0.5.4-nightly.202501160949

5 months ago

0.5.4-nightly.202501151339

6 months ago

0.5.4-nightly.202501171606

5 months ago

0.5.4-nightly.202501181312

5 months ago

0.5.4-nightly.202501151606

6 months ago

0.5.4-nightly.202501131606

6 months ago

0.5.3-nightly.202501070959

6 months ago

0.5.3-nightly.202501100253

6 months ago

0.5.3-nightly.202501081606

6 months ago

0.5.3-nightly.202501061606

6 months ago

0.5.3-nightly.202501090742

6 months ago

0.5.3-nightly.202501101606

6 months ago

0.5.3-nightly.202501110940

6 months ago

0.5.3-experimental.20250106-4af1f4e

6 months ago

0.5.3-experimental.20250106-e3b7a39

6 months ago

0.5.3-nightly.202501071618

6 months ago

0.5.3-experimental.20250107-3e6579c

6 months ago

0.5.3-nightly.202501091606

6 months ago

0.5.3-nightly.202501060906

6 months ago

0.5.3-nightly.202501051605

6 months ago

0.5.3-nightly.202501111605

6 months ago

0.5.2-nightly.202501031606

6 months ago

0.5.2-nightly.202501021606

6 months ago

0.5.3-nightly.202501041605

6 months ago

0.5.2-nightly.202412311606

6 months ago

0.5.3

6 months ago

0.5.2-nightly.202412301606

6 months ago

0.5.2-nightly.202501011606

6 months ago

0.5.2-nightly.202412291605

6 months ago

0.5.2-nightly.202412281605

6 months ago

0.5.1-nightly.202412231606

6 months ago

0.5.1-nightly.202412261606

6 months ago

0.5.1-nightly.202412221605

6 months ago

0.5.1-nightly.202412241606

6 months ago

0.5.2

6 months ago

0.5.1-nightly.202412251606

6 months ago

0.5.1-nightly.202412271606

6 months ago

0.5.1-nightly.202412160721

7 months ago

0.5.1-nightly.202412211605

6 months ago

0.5.1-nightly.202412171606

6 months ago

0.5.1-nightly.202412151605

7 months ago

0.5.1-nightly.202412180740

6 months ago

0.5.1-nightly.202412190838

6 months ago

0.5.1-nightly.202412171234

6 months ago

0.5.1-nightly.202412180637

6 months ago

0.5.1-nightly.202412181606

6 months ago

0.5.1-nightly.202412201606

6 months ago

0.5.1-nightly.202412190703

6 months ago

0.5.1-nightly.202412161321

7 months ago

0.5.1-nightly.202412161606

6 months ago

0.5.1-nightly.202412171026

6 months ago

0.5.1-nightly.202412191606

6 months ago

0.5.1-nightly.202412180944

6 months ago

0.5.1-nightly.202412140448

7 months ago

0.5.1-nightly.202412120504

7 months ago

0.5.1-nightly.202412131606

7 months ago

0.5.1-nightly.202412110405

7 months ago

0.5.1-nightly.202412111606

7 months ago

0.5.1-nightly.202412121230

7 months ago

0.5.1-nightly.202412141605

7 months ago

0.5.1-nightly.202412120301

7 months ago

0.5.1-nightly.202412121606

7 months ago

0.5.1-nightly.202412111529

7 months ago

0.5.1-nightly.202412101606

7 months ago

0.5.1-nightly.202412090925

7 months ago

0.5.1-nightly.202412081606

7 months ago

0.5.1-nightly.202412090546

7 months ago

0.5.1-nightly.202412100649

7 months ago

0.5.1-nightly.202412091607

7 months ago

0.5.1-nightly.202412090639

7 months ago

0.5.1-nightly.202412051606

7 months ago

0.5.1-nightly.202412071605

7 months ago

0.5.1-nightly.202412061606

7 months ago

0.5.1-nightly.202412031606

7 months ago

0.5.1-nightly.202412041606

7 months ago

0.5.1-nightly.202412021606

7 months ago

0.5.0-nightly.202411271606

7 months ago

0.5.0-nightly.202411261607

7 months ago

0.5.0-nightly.202411251606

7 months ago

0.5.1

7 months ago

0.5.0-nightly.202411291606

7 months ago

0.5.1-nightly.202412011605

7 months ago

0.5.1-nightly.202411301606

7 months ago

0.5.0-nightly.202411281606

7 months ago

0.5.0-nightly.202411230545

7 months ago

0.5.0-nightly.202411230627

7 months ago

0.5.0-nightly.202411241606

7 months ago

0.5.0

7 months ago

0.5.0-nightly.202411221606

7 months ago

0.5.0-nightly.202411231605

7 months ago

0.5.0-nightly.202411191606

7 months ago

0.5.0-nightly.202411211606

7 months ago

0.5.0-nightly.202411201606

7 months ago

0.5.0-nightly.202411141606

8 months ago

0.5.0-nightly.202411131606

8 months ago

0.5.0-nightly.202411161605

8 months ago

0.5.0-nightly.202411151606

8 months ago

0.5.0-nightly.202411171605

7 months ago

0.5.0-nightly.202411181606

7 months ago

0.5.0-beta.1

8 months ago

0.5.0-beta.0

8 months ago

0.5.0-nightly.202411121606

8 months ago

0.5.0-nightly.202411091605

8 months ago

0.4.2-nightly.202411091134

8 months ago

0.4.2-nightly.202411051606

8 months ago

0.5.0-nightly.202411120616

8 months ago

0.4.2-nightly.202411041606

8 months ago

0.5.0-nightly.202411101605

8 months ago

0.4.2-nightly.202411071606

8 months ago

0.4.2-nightly.202411061606

8 months ago

0.5.0-alpha.0

8 months ago

0.4.2-nightly.202411081606

8 months ago

0.5.0-nightly.202411111606

8 months ago

0.4.2-nightly.202411021605

8 months ago

0.4.2-nightly.202411031606

8 months ago

0.4.2-nightly.202411011606

8 months ago

0.4.2-nightly.202410310419

8 months ago

0.4.1-nightly.202410291304

8 months ago

0.4.2-nightly.202410311606

8 months ago

0.4.1-nightly.202410291249

8 months ago

0.4.2-nightly.202410301606

8 months ago

0.4.1-nightly.202410281606

8 months ago

0.4.0-nightly.202410290723

8 months ago

0.4.1-nightly.202410271605

8 months ago

0.4.2-nightly.202410291606

8 months ago

0.4.1-nightly.202410261605

8 months ago

0.4.2

8 months ago

0.4.1-nightly.202410251606

8 months ago

0.4.1-nightly.202410241606

8 months ago

0.4.1-experimental.20241024-0ebc6ee

8 months ago

0.4.1-experimental.20241024-9717e6c

8 months ago

0.4.1-experimental.20241023-bbb123f

8 months ago

0.4.1-nightly.202410221606

8 months ago

0.4.1-experimental.20241022-507567a

8 months ago

0.4.1-nightly.202410201605

8 months ago

0.4.0-experimental.20241017-da434a2

9 months ago

0.4.0-experimental.d7288c0-20241017

9 months ago

0.4.1-nightly.202410191605

8 months ago

0.4.0-nightly.202410171606

9 months ago

0.4.1-nightly.202410211606

8 months ago

0.4.1

8 months ago

0.4.0

9 months ago

0.4.0-alpha.2

9 months ago

0.4.0-nightly.202410161605

9 months ago

0.4.0-nightly.202410151606

9 months ago

0.4.0-nightly.202410141110

9 months ago

0.4.0-nightly.202410141606

9 months ago

0.3.0-nightly.202410101606

9 months ago

0.4.0-alpha.1

9 months ago

0.4.0-nightly.202410121605

9 months ago

0.4.0-alpha.0

9 months ago

0.3.0

9 months ago

0.3.0-nightly.202410111606

9 months ago

0.4.0-nightly.202410131605

9 months ago

9 months ago

9 months ago

9 months ago

10 months ago

10 months ago

10 months ago

10 months ago

10 months ago

10 months ago