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 Add menu and click on 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

Options

  • Style: Custom height
  • Labels: Pivot table title

Delete

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

Additional actions are available under the Global View.

Edit mode

Edit mode is enabled by default when a new pivot table is created. To toggle between the edit and preview modes, you can click on the edit button on the top right corner of the pivot table.

To edit a pivot table, you can follow these steps:

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