Excel pivot table grand total row not showing

Quick fix: Click anywhere in the PivotTable, then go to PivotTable Design > Grand Totals > On for Rows and Columns. If the bottom row still does not appear, check for a row filter, grouped field, or layout setting that is hiding it. For Excel’s PivotTable display options, see Microsoft Support on showing or hiding grand totals and subtotals; for GETPIVOTDATA basics, see Microsoft Support and ExcelJet’s function examples.

Turn on PivotTable grand totals from Design > Grand Totals > On for Rows and Columns; if the row still does not appear, a row filter, grouped field, or layout choice is hiding the bottom line. Without it, you lose the summary row that confirms totals and can misread the report. This guide shows the exact settings that hide the grand total row and the shortest fix path.

What the missing row means

A missing grand total row usually means the PivotTable is still calculating totals, but Excel is not displaying the row total at the bottom of the report. Start with the PivotTable Design tab, because row totals and column totals use separate controls. Microsoft Support documents these as separate PivotTable display settings, which is why one total can appear while the other stays hidden.

Row grand total vs. column grand total

The Grand Total row appears at the bottom of the PivotTable. The Grand Total column appears at the far right. Those are separate display choices, so one can appear without the other. If the right edge still shows a total but the bottom row is missing, the row control is the one to fix.

Where Excel normally places the total

In a standard PivotTable with row labels and one or more value fields, the grand total for rows usually sits below the last data row. It sums the visible row items, while subtotals sit inside the row groups themselves. If only a subtotal appears, the row grand total may still be off, hidden by layout, or blocked by a filter.

Likely causes, from most to least common

• Grand totals are disabled in the Design tab.
• The wrong totals direction is selected, so Excel shows a column total instead of a row total.
• Field layout or report layout settings hide the bottom row.
• Blank rows, filters, or grouped items leave the row total outside the visible range.
• A subtotal is being mistaken for the grand total row.
• The problem is actually a GETPIVOTDATA formula mismatch, not a missing display row.

Turn grand totals back

If row totals are disabled, restore them from the PivotTable ribbon first. This is the shortest path and the most common fix. Use the Design tab in the PivotTable Tools ribbon, then choose the totals setting that applies to rows.

1. Click anywhere in the PivotTable.
2. Open PivotTable Design on the ribbon. In some Excel builds, this appears as Design under PivotTable Tools.
3. Select Grand Totals.
4. Choose On for Rows and Columns if you want both totals visible.
5. If you only need the row total, choose a setting that includes rows, then check the bottom of the PivotTable.

The expected result is a total row at the bottom and, if selected, a total column at the far right. If only the right-side total appears, the row setting is still wrong or another layout choice is suppressing it.

Check row and column totals

One side can appear while the other stays hidden because Excel treats row and column grand totals as separate display options. A PivotTable can therefore show a grand total column and still hide the grand total row. That is why the bottom row may be missing even when totals are technically enabled.

Confirm the correct result

After changing the setting, look for two visual cues. The row grand total should appear beneath the last item row. The column grand total should appear at the far right, after the last value field. If you only see one of those, the totals control is still not set the way you want.

Common first-timer mistake

A common first-timer mistake is to turn on totals and expect the bottom row to return immediately, then assume Excel ignored the command when the far-right total appears instead. That usually means the rows-and-columns choice was not selected, or the PivotTable layout is masking the row total.

Check layout and filters

If totals are on but the row still seems missing, the PivotTable structure may be hiding it. Field layout, filters, blank rows, and grouped items can change what you can see, even when grand totals are enabled. Check the report structure before changing formulas.

Field arrangement that can hide the row

When row fields are arranged in a compact layout or the report is filtered to a narrow slice of data, the bottom total can be pushed out of view or replaced by a subtotal grouping. Value fields also matter, because the total depends on the value field being summarized at the right level.

1. Click inside the PivotTable.
2. Open the PivotTable Analyze or Analyze tab, then open the Field List.
3. Check whether a row field is filtered to a subset of items.
4. Move or remove fields if the layout is grouping the total in an unexpected place.
5. On the Design tab, check Subtotals settings if the bottom line you see is a subtotal rather than a grand total.

Blank rows, filtered items, and grouped items

Suppose a sales PivotTable shows only two product categories because the rest are filtered out. The grand total row still belongs at the bottom of the visible items, but a filter can make the report look incomplete if you expect the full dataset. Refresh filters and check whether grouped dates or items have changed the visible structure.

Grand total decision tree

Use this checklist when you need the exact branch that is hiding the row. Start at the top and move down until the expected bottom row appears.

Say your PivotTable shows a grand total column on the right, but the bottom row is gone after a layout change. That usually points to a row-total setting or structure issue, not a broken total calculation. If a formula outside the PivotTable is the problem, the display may be fine while the referenced cell is not.

A common distinction helps here: a normal cell reference can point to any cell in a PivotTable, while GETPIVOTDATA pulls a value field total by field name from a pivot_table reference. The generic pattern is =GETPIVOTDATA("field name",pivot_ref). Exceljet’s example formula is =GETPIVOTDATA("Sales",$B$4), and the pivot_table reference can be any cell in the PivotTable; by convention, Exceljet uses the upper left cell.

Keep the two issues separate. If the row is missing on the screen, fix the PivotTable display settings first. If the row is visible but a formula returns the wrong value, then check the GETPIVOTDATA reference, the field name, and the source cell. Microsoft Support notes that GETPIVOTDATA returns data from a PivotTable based on the field structure, so a changed field name or pivot reference can break the formula even when the report looks normal.

GETPIVOTDATA continues to return current PivotTable values after the report changes, but it follows the field names and layout in the formula. If the value field is set to an unexpected summary type, the result can be valid for the PivotTable and still not match what you meant to pull. Microsoft Support and ExcelJet both show that the key checks are the field name, the pivot reference, and the structure of the source PivotTable.

Still not working?

If the row total still does not return, refresh the PivotTable first. If the source data changed, a stale cache can keep the layout from updating cleanly. If that fails, rebuild the PivotTable in a new sheet so the current field setup and totals settings are applied from scratch.

Escalation ladder

1. Right-click the PivotTable and choose Refresh.
2. Open PivotTable Analyze > Refresh if the context menu is unavailable.
3. Check the Values area and confirm the value field is summarized the way you need.
4. Create a new PivotTable from the same source range if the layout has become hard to untangle.

Prevention: After any layout change, recheck Design > Grand Totals and the row field filters before you trust the bottom line.

Frequently asked questions

Why is my pivot table grand total row not showing?

Usually, the row total is turned off under PivotTable Design > Grand Totals, or a row field layout is hiding it. Click inside the PivotTable, open the Design tab, and choose On for Rows and Columns. Then check filters and row grouping if the bottom line still does not appear.

How do I turn on grand totals in a pivot table

Click in the PivotTable, open PivotTable Design, select Grand Totals, and choose On for Rows and Columns. That restores the bottom row and the far-right column when both are enabled. If you only want one side, pick the setting that includes rows or columns as needed.

Why is Excel PivotTable grand total for rows not working?

Check three things in order: totals are enabled, the row field is not filtered down to an unexpected slice, and the layout is not grouping the row in a way that hides the bottom line. If the value field is summarized incorrectly, the number can also look wrong even when the total row is visible.

How do I show grand total for rows in pivot table

Use Design > Grand Totals and choose a setting that includes rows. Then confirm the total appears below the last visible row item. If it does not, open the Field List and review the row fields, filters, and grouping before changing anything else.

Why does my pivot table show a grand total column but not a row?

Because Excel treats them as separate controls. A grand total column at the far right can be on while the grand total row is off. Return to PivotTable Design > Grand Totals and select the option that includes rows, then verify the bottom of the report.

How do I get the grand total back in an Excel pivot table

Start with PivotTable Design > Grand Totals > On for Rows and Columns. If the row still does not appear, refresh the PivotTable and check filters, subtotals, and field placement. For formula-based summaries, use =GETPIVOTDATA("Sales",$B$4) or a similar pivot reference to read the value field directly.