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:
- count the number of values pertaining to one label in the master table
- get the maximal, minimal or average values per each label
- calculate the sum of values per each label
Inserting Pivot table macro
- Switch the Confluence page to the edit mode.
- Start entering {Pivot table} and select the Pivot table macro from the prompted context menu.
- Click Insert.
- The macro will be added to your page.
- Insert your master table into the Pivot table macro.
Before inserting the master table into the macro ensure the following things: - The master table should contain identical labels that will be used for data summarization.
- Columns should have data of the same type. If the column has data of different types, you may get the error when summarizing data.
|
Configuring Pivot table macro