Table Filter and Charts for Confluence add-on allows you to summarize your table data and produce its aggregated view in the form of a pivot table. You can select the column containing labels for summarization or aggregation and set the columns containing number values for calculation. Additionally, you can select the appropriate operation type (sum, count, minimal, maximal and average). While adjusting the macro parameters you can set the decimal and thousands separator, as well as specify the number of decimal places. You can modify settings of your pivot table and save modifications in the macro body while viewing the page. |
Starting from version 3.0.0 Table Filter add-on allows you to generate pivot tables from the data tables. A pivot table is such a kind of a table that allows you to get the summarized and aggregated data values from the master table.
The Pivot table macro allows you to perform the following operations:
There exist three ways to insert the Pivot Table macro on the page.
Macro Insertion | Instructions | Supported Data | |
---|---|---|---|
Inserting the macro through the action icon on the editor pane |
|
| |
Manual entry of the {Pivot Table} query on the page |
|
| |
Selection of the Pivot Table macro in the Select Macro form |
|
|
Before inserting the table into the Pivot Table macro ensure the following things:
|
On the Confluence page opened in the edit mode, click the Pivot table macro.
Click Edit.
In the Edit Pivot table Macro form, define parameters of the macro, as follows:
Creation of multidimensional pivot tables is available since Table Filter and Charts 3.8.0. |
On the Confluence page opened in the edit mode, click the Pivot table macro.
Click Edit.
Please consider the following while configuring parameters of the Pivot Table macro:
|
Once you have defined settings of the Pivot table macro and saved the page, you get a pivot table with summarized data.
The generated pivot table may be compromised of two or more columns. The number of columns in the final pivot table depends mainly on the number of columns selected in the row and column labels, and calculated columns.
You can quickly update the data series used for calculation as well as update sets of columns selected in row and column labels.
If you deal with the multidimensional pivot tables, you can collapse specific horizontal and vertical levels of the pivot table by clicking the collapse icon. To expand the collapsed level of the table, click icon.
The Total row shows the calculated value throughout the pivot table and for specific levels of the pivot table.
To update the data series for summarization or aggregation:
To save new parameters in the macro body:
To export the pivot table to PDF or Word:
To show the source table:
To save changes in the pivot table: