Table Filter, Charts & Spreadsheets for Confluence - Knowledge base

Page tree

Versions Compared

Old Version 1

changes.mady.by.user Nikita Kamai

Saved on

compared with

New Version Current

changes.mady.by.user Nikita Kamai

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space TFAC and version Draft
Excerpt
hiddentrue


Group your data against chosen parameters and perform simple calculations.

Pivot Table is one of the macros bundled in the the Table Filter and , Charts for Confluence& Spreadsheets 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:

Add Pivot Table on the page

Section
Column
width700px
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
width700px
Panel
borderColor#3b7fc4
titleColor#FFFFFF
titleBGColor#3b7fc4
borderStylesolid
titleStep 2. Select columns for calculation and aggregation:


Column
Read more:
Section
Column
width700px
Panel
borderColor#3b7fc4
titleColor#FFFFFF
titleBGColor#3b7fc4
borderStylesolid
titleStep 3. Select the appropriate operation type:


Column
Read more:

Find the answer to your question among the related FAQ

Section
Column
width170px

Column

Filter tables with the help of the various filter types

Section
Column
width170px

Column

Build various charts based on your table


Section
Column
width170px

Column

Merge multiple tables, perform complex calculations and custom transformations

Section
Column
width170px

Column

Use only one source table to build multiple charts and pivot tables

Section
Column
width170px

Column

Output tables from CSV or JSON

Section
Column
width170px

Column

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