The Source Table:
Table Filter & Office Excel
1. Add the Table Filter macro to the Office Excel macro.
2. Add filters to the table columns and set filter values.
Default sorting in the Table Filter macro can't be applied as Sorting in the header row doesn't work with tables outputted by the Office Excel macro in Confluence by default.
Table Transformer & Office Excel
5. Add the Table Transformer macro to the filtered and aggregated Excel table.
You can place one or multiple tables within the macro body to merge, look up them or to perform custom calculations.
7. Enter the following SQL query to rename columns in the pivot table:
You can change the filtration criteria, the pivot table and chart parameters on the fly.
The changes will be automatically applied to the data from the Office Excel macro.
The Office Excel macro can be used with each of the macros separately or combined with them according to your needs.