# Baserow Footer Aggregation - Column Sums and Averages

> A column's total, average, min, max, or another statistic shows up automatically in the Baserow grid footer - no formula field or spreadsheet export needed.

Source: https://opennix.org/en/docs/baserow/fields/footer-aggregation/


The footer row of a Baserow grid view calculates a column's total, average, or other statistic automatically, no formulas or exports required. This article covers how to turn a field summary on, which functions are available for each field type, and how summaries behave once you start filtering or grouping.

## Overview

A field summary shows a calculated value in the footer row at the bottom of a grid view column - an instant statistical read on that data. The calculation updates automatically as the underlying data changes, giving you real-time analytics without a separate formula field or an export to another tool.

Every [field type](/docs/baserow/fields/baserow-field-overview/) exposes the summaries that make sense for it: number fields calculate sums and averages, date fields show the earliest and latest date, boolean fields count checked items, and text fields count unique values. Assign a different summary to each field and the footer starts to read like a compact summary row that answers the table's key questions at a glance.

Summaries respect any active filters and sorts - they calculate against the visible rows only. That dynamic behavior lets you analyze a filtered subset without restructuring the table or building a duplicate view.

![Field summaries in a Baserow grid view](/images/baserow/fields/baserow-footer-aggregation-overview.webp)

## When to use field summaries

**Financial tracking:** show total revenue, average order value, or a count of paid invoices right at the bottom of a sales table.

**Project management:** display total hours logged, a count of incomplete tasks, or the percentage of completed items across the team.

**Inventory management:** calculate total stock quantity, count items below the reorder point, or show the most recent stock-update date.

**Data quality checks:** spot empty fields that still need filling in, count unique customers, or find outliers with min and max.

**Performance analysis:** track average ratings, median response times, or standard deviation to understand how the data is distributed.

## How to add a field summary

Apply a summary to any field in grid view through its footer cell.

**To add a summary:**

1. open the table in [grid view](/docs/baserow/view-types/guide-to-grid-view/);
2. scroll to the bottom of the table to reach the footer row;
3. hover over the **footer cell** beneath the field you want to summarize;
4. click the footer cell to open the summary menu;
5. pick the function you want from the list;
6. the calculated value appears in the footer immediately.

**To change a summary:** click the footer cell again and pick a different option - the value updates instantly.

**To remove a summary:** click the footer cell and select "None."

## Summary types by field category

> Lookup fields don't support summaries. To analyze looked-up data, create a rollup field with the aggregation you need instead.

**Universal options:** None, Empty, Filled, Percent empty, Percent filled, Unique, and Distribution.

### Summary options for text and selection fields

Text fields (single line text, long text, email, URL, phone number), selection fields (single select, multiple select), and file fields offer summaries focused on data quality and completeness:

| Summary | Calculates | Example use |
|---|---|---|
| **Empty** | Count of blank cells | Tracking missing information |
| **Filled** | Count of populated cells | Data-entry progress, records with a value |
| **% Empty** | Percentage blank | A data-quality score |
| **% Filled** | Percentage populated | Completion percentage |
| **Unique** | Distinct values | Customer count, category count |

> Link-to-table, multiple select, and file fields don't support Unique and Distribution.

### Summary options for count, number, and rating fields

Number, count, rollup, and rating fields offer full statistical calculations:

| Summary | Calculates | Example use |
|---|---|---|
| **Sum** | Total of all values | Total revenue, total hours |
| **Average** | Mean value | Average order value, average rating |
| **Median** | Middle value | Typical salary (ignores outliers) |
| **Min** | Smallest value | Lowest price, minimum inventory |
| **Max** | Largest value | Highest price, maximum capacity |
| **Std deviation** | Spread around the mean | Data variability, quality consistency |
| **Variance** | Squared deviation | Statistical analysis, risk assessment |

> Duration fields don't support Variance, Std deviation, Average, or Median.

### Summary options for date and time fields

Date, created-on, and last-modified fields show temporal boundaries:

| Summary | Calculates | Example use |
|---|---|---|
| **Earliest date** | Oldest date in the field | Project start date, first customer |
| **Latest date** | Newest date in the field | Most recent activity, latest update |

If a date field shows a different time to different collaborators, fix its timezone first - see [Working with Timezones](/docs/baserow/fields/working-with-timezones/) for the details.

### Summary options for boolean fields

Boolean (checkbox) fields track checked versus unchecked state, useful for tracking completion or binary splits:

| Summary | Calculates | Example use |
|---|---|---|
| **Checked** | Count of checked boxes | Completed tasks, active items |
| **Unchecked** | Count of unchecked boxes | Pending tasks, inactive items |
| **% Checked** | Percentage checked | Completion rate, adoption rate |
| **% Unchecked** | Percentage unchecked | Remaining work, gap analysis |

**Use case:** track project completion by showing "% Checked" on a "Task complete" boolean field - and see instantly that 73% of tasks are done.

## How summaries behave with filters and groups

### Summaries under active filters

Field summaries calculate against **visible rows only**. Apply a filter and the summary value updates automatically to reflect that filtered subset, letting you analyze filtered data without a separate view or a manual calculation.

### Summaries with grouped rows

When you use [row grouping](/docs/baserow/views/group-rows-in-baserow/), summaries calculate across **every visible row** in the view, not per group - the footer shows one aggregate value for the whole filtered dataset.

Each group header still shows its own row count, but statistical summaries appear only in the main footer.

## Frequently asked questions

**Can I use a field summary's value inside a formula or another calculation?** No, field summaries are display-only calculations shown in the grid view footer - they can't be referenced in a formula or elsewhere. To use an aggregated value in a calculation, create a [rollup field](/docs/baserow/field-types/rollup-field/) that performs the aggregation at the data layer instead.

**Do summaries calculate over every row, or just the visible ones?** Field summaries calculate over **visible rows only**, respecting active filters, sorts, and search results. That lets you analyze a subset of the data by filtering first, then reading the summary of what's left.

**Can different views of the same table show different summaries?** Yes, field summaries are view-specific - configure "Sum" in one grid view, "Average" in another, and no summary at all in a third, all for the same field on the same table.

**Why can't I add a summary to my lookup field?** Lookup fields display data pulled from a linked table and don't support a direct summary. Build a [rollup field](/docs/baserow/field-types/rollup-field/) instead - rollups support every aggregation function, including sum, average, and count.

**Do summaries work in view types other than grid, like gallery?** No, field summaries are exclusive to grid view since other view types don't display a footer row. If you need summary data elsewhere, build [formula fields](/docs/baserow/formula/understanding-formulas/) or rollup fields that display the aggregated value instead.

**How do I export a field summary's value along with my data?** Field summaries don't export with the data - they're calculations shown only in the view's interface. To include an aggregated value in an export, create a [formula field](/docs/baserow/formula/understanding-formulas/) or a rollup field that calculates it at the data layer, then export the table including that field.

## What's next

That wraps up the Fields section - from the primary field and the full list of field types through configuration, timezones, and footer summaries. Head to [Views](/docs/baserow/views/) next to cover grid, gallery, and form views, along with the [filters](/docs/baserow/views/filters-in-baserow/) and [row grouping](/docs/baserow/views/group-rows-in-baserow/) referenced throughout this section.