User guide

Build a rollup from source rows.

Create the table, add calculated columns, choose the grouping order, and save. Readers get the same values and explanations you see in the editor.

Release status

Rollup 2.3.0 is approved and released on Atlassian Marketplace. Dated development test results below describe the scope of those checks.

1. Add the macro and source rows

  1. Insert Rollup Table on a Confluence page.
  2. Name the report and its data columns.
  3. Type values into the rows or choose a UTF-8 CSV file.
  4. Review calculations and grouping, then choose Save table.
  5. Publish or update the Confluence page so readers can open the saved result.

CSV uses its first row as column names. A compatible import preserves calculated columns, grouping, and summaries. If the source shape is incompatible, Rollup explains which configuration would reset and waits for review before replacing rows. Invalid CSV leaves the existing draft intact.

2. Add calculated columns

Choose + Formula column, give it a unique name, and enter a formula. Column names appear in square brackets. A leading = is optional.

Formula rules

3. Group and summarize

In Group and summarize, add grouping columns in the order readers should see them. For example, Vendor followed by Cost centre produces one vendor section with cost-centre sections inside it.

Add any of these summaries to a source or calculated column:

SUMAdd numeric values.
AVGAverage numeric values.
COUNTCount nonblank values, including text, booleans, and zero.
MIN / MAXFind the smallest or largest numeric value.

Blank values are skipped by summaries. A nonnumeric value or formula error makes a numeric summary show an explanation instead of a misleading partial answer. Grand totals summarize source rows once, even when the report has several grouping levels. Text-only and boolean-only columns are omitted from numeric grand totals.

Understand errors

Formula syntax is checked while you type. Save stays disabled until syntax and reference errors are fixed. At runtime, the affected cell explains errors such as a nonnumeric value, division by zero, an impossible date, or a nonboolean IF condition. Dependent calculated cells and summaries carry that explanation forward.

The editor and published reader use the same calculation path. On 19 September 2026, the development installation was checked with numeric-format, division-by-zero, impossible-date, and nonboolean-IF failures; both surfaces showed matching errors.

Limits and large reports

RowsUp to 10,000 per report.
ColumnsUp to 100.
Cell textUp to 10,000 characters.
FormulaUp to 2,000 characters.
Saved report4.5 MB serialized configuration safety budget.
CSV file10 MB input limit.

A synthetic 5,000-row, 9-column fixture was saved, published, and reloaded in development on 19 September 2026. It preserved exact CSV rows, three formulas, two grouping levels, and five summaries. The saved report JSON measured 1,066,756 bytes; the enclosing macro configuration JSON measured 1,216,977 bytes. This one fixture shows tested behavior, not a promise that every report under the limits has the same speed or size.

Get help

See support and security reporting for the contact address and the details that help diagnose a report. Do not email real CSV files or confidential cell values.