Stockertim Dictionary · Technology · Accounting
Grand total
Also called grand totals, overall total, report total
In short
The overall total at the bottom or right edge of a pivot table or report, which should agree with the total of the source data it summarises.
- Beginner
- Concept
- Checked
In detail
A grand total sums or summarises everything in a report, as opposed to subtotals for each group. In a pivot table there can be two: a row of grand totals across the bottom and a column of grand totals down the right edge, either of which can be switched off in the layout options. Where they meet sits the single figure for the whole report.
The grand total follows the summary function of the value field. For a sum it is the sum of everything; for a count, the number of records; for an average, the average of all underlying records rather than the average of the group figures above it. That last point explains why a grand total of averages often does not equal the mean of its subtotals.
Its most practical use is as a control. The grand total of a pivot built on the whole data set should equal a simple =SUM of the source column. If it does not, something is wrong: the pivot was not refreshed after new rows arrived, its source range stops short, a filter or slicer is excluding records, or some amounts are stored as text and were left out. Agreeing the two figures takes seconds and catches each of these.
Filters change what the grand total covers. With a region filter applied, the total describes only the visible regions, so a report that is circulated filtered should say so. Showing values as a percentage of the grand total also shifts when items are filtered out.
Worked example
A logistics firm in Durban summarises 1,000 delivery charges by depot. The pivot grand total shows 84,600, but =SUM over the source column gives 86,100.
- Difference: 86,100 − 84,600 = 1,500
- The pivot's source range ended at row 980; the last 20 rows hold 1,500 of charges
- After extending the range and refreshing, the grand total shows 86,100
Agreeing the grand total to the source exposed rows the pivot had missed.
In practice
Finance teams tie the grand total of every summary to the ledger or source extract before a report goes out, often in a small check cell that shows zero when the figures agree.
Watch out
- A filtered pivot's grand total covers only the visible items.
- For averages, the grand total is the overall average, not the average of the subtotals.
Learn it properly
- Pivot tables, charts and a simple dashboard15 min lesson Free course: Excel and spreadsheets with AI
- Pivot tables and summaries15 min lesson Free course: AI for data analysis: spreadsheets and BI
- IF, SUMIFS and COUNTIFS15 min lesson Free course: Excel and spreadsheets with AI
- Pivot tables for financial data15 min lesson Free course: Financial data and spreadsheets
Official sources
Facts last checked on 9 November 2026.
Education, not advice: the Stockertim Dictionary explains what terms mean. It never recommends buying or selling anything.