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

Step 1. Add the macro to your table. Choose the handy way to do this:

To add macros in view mode:

  1. Click the More actions (⋯) menu in the top-right corner of the page.

  2. Go to Apps → Use Table Filter App Macros.

In edit mode, macros are added just like any other Confluence macros:

  • Start entering /Pivot Table and select the macro.

  • On the editor pane, click  Insert -> View more, find the macro and insert it on the page.

Make sure the source table - whether manually created or generated by another macro - is placed inside the macro body.

Read more:
Step 2. Select columns for calculation and aggregation:

Read more:
Step 3. Select the appropriate operation type:

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