# Pivot Table

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

![](https://gcdocumentsitekrblob.blob.core.windows.net/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/pivottable_quickstart.png)

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.

![](https://gcdocumentsitekrblob.blob.core.windows.net/document-site-files/images/8d606653-16a0-474d-b9dc-e2b4d01c2446/images/pivottable.gif)

For using a pivot table and its various features, refer to the below topics:

| **Features** | **Description** |
| -------- | ----------- |
| [Pivot Table Components](/spreadjs/docs/v16/features/pivot-table/pivot-table-components) | Describe pivot table structure, components, and elements |
| [Create Pivot Table](/spreadjs/docs/v16/features/pivot-table/create-pivot-table) | Create Pivot Table in the spreadsheet through code |
| [Filter](/spreadjs/docs/v16/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/v16/features/pivot-table/sort-pt) | Sort the data in the pivot table |
| [Group and Collapse](/spreadjs/docs/v16/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/v16/features/pivot-table/refresh-data-source) | <span style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">Describes how to reflect the data source update in the pivot table and edit data area values in the pivot table.</span> |
| [Pivot Table Layout](/spreadjs/docs/v16/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/v16/features/pivot-table/themes-and-style) | Change the theme and style of the pivot table:<ul><li>Themes</li><li>Style</li></ul> |
| [Context Menu](/spreadjs/docs/v16/features/pivot-table/context-menu) | Describe context menu options |
| [Pivot Table Settings](/spreadjs/docs/v16/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/v16/features/pivot-table/pivot-view-manager) | Add, modify and delete Pivot Table views |
| [Pivot Table Print](/spreadjs/docs/v16/features/pivot-table/pivot-table-print) | Print pivot table |