How to create a pivot table in Confluence
A pivot table summarizes repeated records by one or more categories. Start with clean row-based data where every column has a consistent meaning.
Prepare the source
Use one record per row. Keep categories such as region, owner, or status in separate columns, and store measurable values as numbers.
Configure the pivot
Open the Simple Tables pivot configuration, select the row dimensions, choose the value column, apply the relevant aggregation, and review the generated summary.
- Choose categorical row fields
- Choose the numeric value
- Select sum, average, count, or another supported aggregation
- Check totals and empty categories
Publish a readable summary
Use concise labels and avoid too many dimensions in a single view. If readers need the underlying records, link the pivot summary to a normal grouped table on the same page.
Related Simple Tables documentation
Frequently asked questions
What data shape works best for a pivot table?
A flat record set with one row per event or item and separate categorical and numeric columns.
Can I count rows instead of summing a number?
Yes. Count is one of the documented aggregation patterns.