Aggregations

Aggregations calculate a summary value across every row currently in the report and display it in the footer row, directly under the column it summarizes. This is how you answer questions like “what’s the total budget across all these projects?” or “what’s the average deal size in this pipeline?”.

Supported Field Types

Aggregations are available for numeric column types:

• Number
• Currency
• Percent
• Time Duration
• Rating
• Formula (when the formula resolves to a number)

Non-numeric columns — like Title, Tags, or Date — don’t show aggregations.

Available Aggregation Types

For each numeric column, you can pick one of:

• Sum — Adds every value in the column
• Average — Mean of all values
• Min — The smallest value
• Max — The largest value
• Count — How many rows have a value in the column

Enabling Aggregations

Aggregations are opt-in per column. When creating or editing the report, each numeric column has an aggregation selector. Pick the type you want or leave it off to keep the footer empty for that column.

Formatting

Aggregation values are formatted to match the column type — currency columns show the currency symbol, percent columns show the % sign, time duration columns use the same duration format as the cells themselves. This means a Sum over a Currency column in USD reads as $124,500.00, not just 124500.

Filter-Aware

Aggregations always reflect the rows currently visible in the report. If you apply a view-level filter that narrows the table, the footer totals update to match. Same goes for filters baked into the report’s data sources.