> ## Documentation Index
> Fetch the complete documentation index at: https://docs.retailgrid.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Totals row

> Read the pinned totals row that aggregates every calculated metric over your exact filtered set.

The **totals row** is a pinned row at the bottom of the grid that rolls every calculated metric column up over the rows you're actually looking at. It always reflects the active filters, scope, and forecast horizon, so you can see the overall sales and margin impact of a repricing without exporting first.

## Show or hide the totals row

Toggle the totals row with a click. Its collapsed or expanded state is remembered per user, so the grid opens the way you left it.

## It follows your filters

The totals are computed on the backend over the exact filtered and scoped row set - not just the rows currently loaded on screen. Filter to a category, a brand, or any slice and the totals recompute for that slice. Change the forecast horizon and the forecast columns re-total to match. A manual export of the same filtered rows reproduces every total.

## How each metric is aggregated

Not every metric should be added up. A price can be averaged; a margin percentage can't - averaging ratios gives the wrong answer. The totals row aggregates each column by its correct semantics:

* **Summed** - count- and money-style quantities: Sales Units, Sales Value, Gross Profit, Stock, Cost of Inventory, Value of Inventory, average daily sales, and the forecasted and change (Δ) columns.
* **Averaged** - per-unit and rate columns: Price, Cost, RRP, Regular Price, Proposed Price, Tax Rate %, Elasticity, Price Change %, competitor prices, and custom number columns.
* **Recomputed from totals** - ratios are rebuilt from their aggregated parts, never averaged: Gross Margin % (total gross profit ÷ total sales value), Average Selling Price, Run Rate (days), GMROI, and CPI (Min / Mode).
* **Sales-weighted** - Unit Margin % and New Unit Margin % are weighted by each row's sales value, so high-volume SKUs count most.
* **Count or share** - Is Promo shows a count of promo items; Cheapest Flag shows the share of products where you're the cheapest.

A few columns stay blank in the totals row where a correct total isn't available from the visible data - Cost Coverage %, Sell-through %, Inventory Turnover, and Realized Discount %, along with text, date, and status columns.

## Read it at a glance

The totals row is styled to stand apart from your data. Regular grid rows are plain - no colored backgrounds and no red or green text - so color accents appear only in the totals row, and it reads as clearly separate from the last product row.

## Related

* [Metrics glossary](/reference/metrics)
* [Configure grid](/grids/configure-grid)
* [Views](/grids/views)
* [Export data](/grids/export)