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 + View 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.

Settings

Options

  • Style: Custom height
  • Labels: Pivot table title

Delete

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

Additional settings are available under the Global View.

Edit mode

The edit mode is enabled by default when a new pivot table is created. To see the pivot table as page viewers do, toggle off edit mode using the edit button in the top-left corner.

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

Pivot tables are not copied when a page is copied. They need to be added again to the new page.