S
Simpleasyty
Help Center — Footer aggregation
GETTING STARTED
IntroductionInstall the appQuick startRuns on Atlassian
SIMPLE TABLE
PasteAttachmentsFile uploadJoin tablesPage PropertiesConfluence ContentJira Issues
TABLE WITH BODY
Native Confluence tables
DATA STORAGE
Data residencyNo data egressSave table data
REUSE TABLES
Table Excerpt / Include
DISPLAY
SearchFiltersSortingGroupingRow numbersFull screen modeDownload tableConfidential labelRovo
COLUMNS
ReorderingRename headingHideIncognito modeText appearanceColumn colorsData typeGrouping aggregationFooter aggregationCalculated columnExpression functionsNested JSON fieldsDelete column
PIVOT TABLES
Overview
FORMATTING
Layout & spacingTable colorsTable heightPagination

Footer Aggregation

Add automatic aggregations to the footer row of your table. Footer aggregations summarize column values and display the result beneath the table.

COLUMNS

How footer summaries work

Current table view Selected column Footer row

A footer aggregation summarizes the values currently shown in a column and displays the result beneath the table. Use it when you want a quick overall summary without enabling grouping.

Each column can use a different footer function. The source rows and their values stay unchanged.

Add a footer summary

Choose the column to summarize, then select the 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 the function that fits the column

The choices adapt to the column type, so you only see calculations that make sense for that data.

Function Use it for
Any columnMeasure records or unique values.
Count 42 rows → 42 Counts the rows in the current table view.
Count distinct Ana, Ken, Ken, Maya → 3 Counts unique, non-blank values.
Number columnsCalculate a numerical summary.
Sum 120, 80, 50 → 250 Adds numeric values; blanks are ignored.
Average 4.6, 4.9, 4.0 → 4.5 Calculates the arithmetic mean.
Minimum / Maximum 7, 3, 5 → 3 / 7 Returns the smallest or largest value.
Enum columnsDescribe the values in a category.
Values Open, In progress, Done Lists the values represented in the footer.
Mode In progress, Blocked, In progress → In progress Returns the most frequent value.

Check the overall project budget at a glance

A project team tracks planned and actual spend across many workstreams.

Before
Readers have to scan every row or export the table to understand the overall spend.
After
The team adds a Sum footer aggregation to both amount columns. The totals remain visible at the bottom while every line item stays available.

RELATED RECOMMENDATIONS

Continue shaping the summary

Use grouping when readers need detail inside categories, or choose column data types that keep the footer calculations meaningful.

Column aggregations Show totals, counts, and other summaries for grouped data. Grouping Turn repeated values into clear, expandable sections. Column data types Keep values in a meaningful order when sorting and filtering.