CONFIGURE COLUMNS
Footer aggregation
Show a summary at the bottom of a numeric column.
Add a footer summary
Choose the column and calculation that should appear at the bottom of the table.
- 1
Open Columns
Edit the macro and switch to the Columns tab.
- 2
Expand the metric column
Click the column whose total, count, or other summary you want to show.
- 3
Choose Footer aggregation
In Aggregations, select a function from the Footer aggregation menu. The preview adds the result beneath the table immediately; save or publish the page when you are done.
Choose a summary
The menu adapts to the selected column’s data type.
| Column type | Function | What appears in the footer |
|---|---|---|
| Any type | Count | Number of rows in the current result. |
| Any type | Count distinct | Number of different non-empty values. |
| Number | Sum / Average | Total or average of the numeric values. |
| Number | Min / Max | Smallest or largest numeric value. |
| Enum | Values / Mode | Category counts or the most frequent category. |
Example: total sales
Set Sales to Sum. The original rows remain available.
- Sales values
- 120 · 80 · 50
- Footer sum
- 250
How the footer behaves
A footer summary changes the displayed result, not the source data.
Current result
The footer recalculates for the rows currently included by filters and search.
One choice per column
Each column can have its own function. For example, sum Sales and count Orders.
Original values
The calculation adds a footer value; source rows remain unchanged.