Pivot Table tab

The Pivot Table tab in the Spreadsheet Editor allows creating and editing pivot tables.

Starting from ONLYOFFICE Docs version 8.2, the Pivot Table tab is hidden by default and will open only while working with pivot tables.

The corresponding window of the Online Spreadsheet Editor:

The corresponding window of the Desktop Spreadsheet Editor:

Using this tab, you can:

• create a new pivot table,
• choose the necessary layout for your pivot table,
• update the pivot table if you change the data in your source data set,
• select an entire pivot table with a single click,
• expand or collapse fields to show/hide the details for the pivot table items,
• highlight certain rows/columns by applying a specific formatting style to them,
• choose one of the predefined tables styles.