View Source

Group your data against chosen parameters and perform simple calculations.

Pivot Table is one of the macros bundled in the Table Filter, Charts & Spreadsheets app. The macro allows you to summarize your table data and produce its aggregated view in the form of a pivot table. You can select the appropriate operation types as follows:

Add Pivot Table on the page

Table Filter, Charts & Spreadsheets for Confluence > How to use Pivot Table macro > adding the macro (pivot).gif

Read more:

Table Filter, Charts & Spreadsheets for Confluence > How to use Pivot Table macro > pivot columns.gif

Read more:

Configuring the pivot table

Table Filter, Charts & Spreadsheets for Confluence > How to use Pivot Table macro > operation type.gif

Read more:

Find the answer to your question among the related FAQ

Filter tables with the help of the various filter types

Build various charts based on your table

Merge multiple tables, perform complex calculations and custom transformations

Use only one source table to build multiple charts and pivot tables

Output tables from CSV or JSON

Combine all the macros with each other and with built-in and third-party macros