Page History

Pivot Table is is a macro bundled within Table Filter and , Charts & Spreadsheets for Confluence add-onapp. It allows you to create pivot tables with aggregated and summarized data on the basis of repeated values from the source table.

Parameters

The add-on adds the Pivot table macro. You can add this macro onto your Confluence page and further paste any table into the macro body. You can also insert the macros that generate the table data and get a pivot table with aggregated values. The following parameters are available to you:

Pivot tables in Confluence

You can expand the section below and see the source table that is used for generation of a pivot table with aggregated values.

You can use the dedicated panel to change the calculated column and select the appropriate operation type from the following ones:

• Count - counts the number of values pertaining to one label in the source table.
• Max - determines the maximal value per each label.
• Min - determines the minimal value per each label.
• Average - calculates the average values per each label.
• Sum - calculates the sum of values per each label.

Feel free to work with the sample Pivot table for getting aggregated data values. You can always save any modifications made in the macro's parameters by clicking Save settings in the page view mode.

Sample Pivot Table

Feel free to work with the sample Pivot table for getting aggregated data values. You can always save any modifications made in the macro's parameters by clicking Save changes.