Pivot Table

• Mar 19, 2021
• 2 minutes to read

This document introduces the Pivot Table functionality, which allows you to perform complex analysis of raw data in a worksheet using pivot tables.

A pivot table represents a summary table used to explore, analyze and aggregate huge amounts of data in a worksheet. It allows you to divide your data into categories and subcategories, and automatically calculates subtotals and grand totals using the most suitable summary function from a predefined list. For example, the image gallery below shows a table with raw data and a PivotTable report built based on this table.

Source Data

PivotTable Report

Manage Pivot Tables in the User Interface

• Insert a Pivot Table

• Organize the PivotTable Structure

• Adjust the PivotTable Options

• Explore the PivotTable Data