Column totals row, sum your numeric fields without leaving the table
Tables now grow a smart totals row that sums Number, Quantity, Total, and Calculation fields, and updates live as you filter or inline-edit.
- Automatic totals for Number, Quantity, Total, and Calculation fields
- Live recalculation when filters or inline edits change the visible rows
- Configurable per table from the Table Builder Display Options
- Minimum padding/width tuning so calculation columns never squish
Why this release matters#
If you’ve ever watched a client paste your CSV into Excel just to type =SUM(B:B) at the bottom, this one’s for them. Gravity Tables 4.1.8 introduces a summary row that lives on the table itself.
It’s not a new widget, not another shortcode parameter to memorise, and not a separate report screen. It’s the most natural place for a number to live: directly under the column it’s summing.
What’s actually new#
A real, dynamic totals row#
The new “Show totals row” toggle in Table Builder → Display Options lights up a footer row in your table. The row inspects every column and:
- Sums Number, Quantity, Total, and Calculation fields
- Counts non-numeric columns (so you still see “5 entries” or “12 active”)
- Re-runs the math the instant you filter, sort, search, or inline-edit a value
This isn’t a static wp_options cache. The total is computed from the currently visible rows, which means the moment you filter to “Active customers in February”, the MRR total reflects exactly that slice.
Numeric column hygiene#
Calculation and Total columns now ship with sensible minimum widths and padding so totals don’t get visually crushed in narrow layouts. Small touch, big difference on dashboards displayed on actual monitors.
Upgrade path#
This is a backwards-compatible minor release. To enable on existing tables:
- Tables → Edit table → Display Options
- Flip Show totals row to on
- Save
No shortcode changes required. No data migration. No database writes beyond the standard table-settings update.
What’s coming next#
Totals are the foundation for conditional formatting (heat-map cells, status colours from numeric thresholds) and comparison rows (compare this month’s totals to last month’s). Both are queued for the 4.2 line.
If you have a particular calculation pattern you’d love to see, a percentage row, weighted averages, group-by sub-totals, reply to the release email or email us. We read every one.