← All articles

Grid, Board & Gallery — Totals at the foot of a column

Summarise in the toolbar (or any column's own menu) puts an aggregate in a row pinned to the bottom of the grid. Numbers offer sum, average, min, max and median; dates offer earliest and latest; checkboxes offer checked, unchecked and % checked; and every field type offers filled, empty, % filled, % empty and unique values. The figure is worked out by the database over every row the view matches, not over the rows currently loaded — which is the point of having it, and the reason it doesn't climb as you scroll further down. When the grid is grouped, each group carries its own totals in its header rather than in a row underneath, so they stay readable when the group is collapsed — which is where a group total earns its keep.
Nothing here answered it? Ask us directly — we usually reply within one working day.

Made with RowFold