Check out our Cloud apps to improve your experience in Jira and Confluence Cloud.
Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Pivot Table is one of the macros bundled in the Table Filter and Charts for Confluence app. The macro allows you to summarize your table data and produce its aggregated view in the form of a pivot table. You can select the appropriate operation types as follows:

How to

use Table from CSV macro

How to get started?



Section


Column
width830px


Panel
borderColor#3b7fc4
titleColor#FFFFFF
titleBGColor#3b7fc4
borderStylesolid
titleStep 1. Add the macro to your table. Choose the handy way to do this:





Column

Read more:



Section


Column
width830px


Panel
borderColor#3b7fc4
titleColor#FFFFFF
titleBGColor#3b7fc4
borderStylesolid
titleStep 2. Select columns for calculation and aggregation:





Column

Read more:



Section


Column
width830px


Panel
borderColor#3b7fc4
titleColor#FFFFFF
titleBGColor#3b7fc4
borderStylesolid
titleStep 3. Select the appropriate operation type:




Column

Read more:








Section


Column
width170px


Column

Filter tables with the help of the various filter types

Children Display
pageHow to use Table Filter macro




Section


Column
width170px


Column

Build various charts based on your table

Children Display
pageHow to use Chart from Table macro





Section


Column
width170px


Column

Merge multiple tables, perform complex calculations and custom transformations

Children Display
pageHow to use Table Transformer macro





Section


Column
width170px


Column

Output tables from CSV




Section


Column
width170px


Column

Combine all the macros with each other and with built-in and third-party macros

Children Display
pageHow to work with multiple macros at once