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.
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.
For using a pivot table and its various features, refer to the below topics:
Describe pivot table structure, components, and elements
Create Pivot Table in the spreadsheet through code
Filter the fields in the pivot table by using:
Sort the data in the pivot table
Create groups according to the data type by using:
Describes how to reflect the data source update in the pivot table and edit data area values in the pivot table.
Change the layout of the pivot table:
Change the theme and style of the pivot table:
Describe context menu options
Modify the settings of the pivot table created in a spreadsheet:
Add, modify and delete Pivot Table views
Print pivot table