Make sure to click on the Smart Table Save button to store the changes for the page viewers.

Create pivot table

To create a pivot table from Smart Tables data, open the actions menu and click on "Add pivot table". Pivot tables are created and managed exclusively from the Confluence page viewer.

Pivot tables allow for the aggregation of data through various calculations. They support data grouping and filtering to focus on specific subsets. By dragging and dropping fields into designated rows and columns, users can view data from multiple perspectives, making it easier to uncover insights, identify trends, and make informed decisions.

Actions

Pivot table options

  • Style: Custom height
  • Labels: Pivot table title

Delete pivot table

From the Actions menu, you can delete the pivot table. 

Edit mode

1. Choose datasets from the available fields and apply filters

2. Drag and drop fields in the Rows and Columns sections

3. Choose to display the data as a table or a chart and select their types 

4. Select aggregation rules

  • Count
  • Count Unique Values
  • List Unique Values
  • Sum
  • Integer Sum
  • Average
  • Median
  • Sample Variance
  • Sample Standard Deviation
  • Minimum
  • Maximum
  • First
  • Last
  • Sum over Sum
  • Sum as Fraction of Total
  • Sum as Fraction of Rows
  • Sum as Fraction of Columns
  • Count as Fraction of Total
  • Count as Fraction of Rows
  • Count as Fraction of Columns

5. Sort subtotals horizontally or vertically

Preview mode

The preview mode allows you to view the data as seen by page viewers