Table Filter for Confluence add-on allows you to summarize your table data and produce its aggregated view in the form of the pivot table. You can select the column containing labels for summarization or aggregation and set the column containing number values. Additionally, you can select the appropriate operation type (sum, count, minimal, maximal and average). Optionally, 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:
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 Pivot Table macro in the Select Macro form |
|
|
Before inserting the table into the Pivot Table macro ensure the following things:
|
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 is comprised of two columns:
The Total row shows the calculated value throughout the pivot table.
To the right side of your pivot table, you can locate the Pivot Table Settings sidebar. It allows you to alternate the following parameters of Pivot table macro:
To save new parameters in the macro body, click Save settings.