@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.