# Pivot Table

An overview of the options SpreadJS Pivot Table add-on component, including UI and links to other PivotTable documentation topics

## Content

Pivot Table is a powerful data analysis tool used to calculate, summarize, and present bulk data in a meaningful manner in a spreadsheet. SpreadJS allows you to use Pivot Tables to analyze the extensive data in spreadsheets, and group the data in different ways to draw helpful conclusions easily.
The following image shows a pivot table created for a food sales company.
![SpreadJS Pivot Table summarizes food sales by grouped row and column fields, displaying category details together with subtotals and grand totals.](https://cdn.mescius.io/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/pivottable_quickstart.png?width=1000)
The data can be broken down into categories and subcategories, the subtotals and grand totals can be displayed, sorting and filtering operations can be applied, and various layouts, styles, and themes can be applied while using a pivot table. The following gif shows how to summarize complex data by using a pivot table in a spreadsheet.
![SpreadJS Pivot Table workflow demonstrates summarizing spreadsheet data through grouping, sorting, filtering, subtotal calculations, and layout changes.](https://cdn.mescius.io/document-site-files/images/b2223940-43c2-44cf-8eda-f5ab9acd84f0/overview-20260303.e86a1d.gif?width=1000)
For using a pivot table and its various features, refer to the below topics:

| **Features** | **Description** |
| -------- | ----------- |
| [Pivot Table Components](/spreadjs/docs/v19/features/pivot-table/pivot-table-components) | Describe pivot table structure, components, and elements |
| [Create Pivot Table](/spreadjs/docs/v19/features/pivot-table/create-pivot-table) | Create a PivotTable from worksheet data, TableSheet data, or DataManager Table/View data through code. |
| [Filter](/spreadjs/docs/v19/features/pivot-table/filter-pt) | Filter the fields in the pivot table by using:<ul><li>Row Fields & ColumnFields Filter</li><li>Value Filter</li><li>Label Filter</li><li>Date Type filter</li><li>Slicer</li><li>TimeLine</li></ul> |
| [Sort](/spreadjs/docs/v19/features/pivot-table/sort-pt) | Sort the data in the pivot table |
| [Group and Collapse](/spreadjs/docs/v19/features/pivot-table/group-and-collapse) | Create groups according to the data type by using:<ul><li>Group Dates</li><li>Group Text</li><li>Group Numbers</li></ul> |
| [Data Settings](/spreadjs/docs/v19/features/pivot-table/refresh-data-source) | Describes how to reflect the data source update in the pivot table and edit data area values in the pivot table. |
| [Dimension Subtotals](/spreadjs/docs/v19/features/pivot-table/dimension-subtotals) | Display one or more subtotal calculations for row or column fields in a PivotTable. |
| [Pivot Table Layout](/spreadjs/docs/v19/features/pivot-table/pivot-table-layout) | Change the layout of the pivot table:<ul><li>Compact Form</li><li>Tabular Form</li><li>Outline Form</li><li>Additional Settings</li></ul> |
| [Themes and Style](/spreadjs/docs/v19/features/pivot-table/themes-and-style) | Change the theme and style of the pivot table:<ul><li>Themes</li><li>Style</li></ul> |
| [Custom Pivot Table Styles](/spreadjs/docs/v19/features/pivot-table/custom-pivot-table-styles) | Manage pivot table themes by retrieving, adding, removing, and updating pivot table styles. |
| [Context Menu](/spreadjs/docs/v19/features/pivot-table/context-menu) | Describe context menu options |
| [Pivot Table Settings](/spreadjs/docs/v19/features/pivot-table/pivot-table-settings) | Modify the settings of the pivot table created in a spreadsheet:<ul><li>AutoFit Column</li><li>Calculated Fields</li><li>Conditional Rule</li><li>Merge and Center Cells With Labels</li><li>Pivot Table ToolTip</li><li>Pivot Table Serialize/Deserialize</li><li>Show Empty Value As</li><li>Pivot Table Show Data As</li></ul> |
| [Pivot View Manager](/spreadjs/docs/v19/features/pivot-table/pivot-view-manager) | Add, modify and delete Pivot Table views |
| [Pivot Table Print](/spreadjs/docs/v19/features/pivot-table/pivot-table-print) | Print pivot table |