Pivot Table Issues

Show Row and Column Grand Totals in an Excel PivotTable

Khadija KhanKhadija Khan Nov 18, 2026 869 views

Question details

Display grand totals for both rows and columns in an Excel PivotTable and filter the displayed dates.

Show Row and Column Grand Totals in an Excel PivotTable
Product
Microsoft Excel
Device & OS
not provided
Scenario
A PivotTable uses dates as columns and activity categories as rows.
Observed behavior
The desired view shows totals across activities and dates, with controls for filtering the date field.
Before you start

Make sure the source data contains date and activity fields, plus a numeric field to summarize. Click inside the PivotTable to display its tools and field list.

Solution 1Recommended

Enable both grand totals in PivotTable Options

Use this method to show totals for every activity row and date column.

1
Arrange the fields

Click the PivotTable and open the Field List if needed. Drag the date field to Columns, the activity field to Rows, and a numeric field to Values.

2
Open PivotTable Options

Right-click inside the PivotTable and select PivotTable Options.

3
Turn on grand totals

Open the Totals & Filters tab, select Show grand totals for rows and Show grand totals for columns, then click OK.

4
Filter the dates

Open the drop-down arrow for the date field in the PivotTable, select the dates you want to display, and click OK.

Enable both grand totals in PivotTable Options
Totals reflect filters: Grand totals update to reflect the data included by the PivotTable filters.
Work with PivotTables in WPS

Show PivotTable grand totals in WPS Spreadsheets

Use WPS Spreadsheets to arrange date and activity fields, enable row and column grand totals, and filter the dates in your PivotTable.

  1. 1. Open the workbook: Open WPS Spreadsheets and choose Open to select your Excel workbook.
  2. 2. Arrange PivotTable fields: Click the PivotTable and use its field list to place dates in Columns, activities in Rows, and a numeric field in Values.
  3. 3. Enable grand totals: Right-click the PivotTable and open PivotTable Options. Under Totals & Filters, enable grand totals for rows and columns, then confirm.
  4. 4. Filter the dates: Open the date field's filter arrow in the PivotTable and select the dates to display.
Summarize activities by date with PivotTable grand totalsOpen and edit Microsoft Excel XLSX filesFilter PivotTable dates to focus on the periods you needWork in a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

Can I show only row or only column grand totals?

Yes. Right-click the PivotTable, select PivotTable Options, and use the Totals & Filters tab to enable only the grand total option you want.

How do I filter dates in the PivotTable?

Open the drop-down arrow for the date field in the PivotTable, select the dates you want, and click OK.

Why do my grand totals change after I filter dates?

Grand totals reflect the data included by the PivotTable filters. Change the date field's filter selection to include the periods you want in the totals.

Where should I put the field I want to total?

In the PivotTable Field List, drag the numeric field to Values. Place the date field in Columns and the activity field in Rows.