Show Row and Column Grand Totals in an Excel PivotTable
Question details
Display grand totals for both rows and columns in an Excel PivotTable and filter the displayed dates.

- 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.
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.
Enable both grand totals in PivotTable Options
Use this method to show totals for every activity row and date column.
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.
Right-click inside the PivotTable and select PivotTable Options.
Open the Totals & Filters tab, select Show grand totals for rows and Show grand totals for columns, then click OK.
Open the drop-down arrow for the date field in the PivotTable, select the dates you want to display, and click OK.

Turn on grand totals from the Design tab
Use the ribbon for a quick way to enable both grand totals.
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. Open the workbook: Open WPS Spreadsheets and choose Open to select your Excel workbook.
- 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. Enable grand totals: Right-click the PivotTable and open PivotTable Options. Under Totals & Filters, enable grand totals for rows and columns, then confirm.
- 4. Filter the dates: Open the date field's filter arrow in the PivotTable and select the dates to display.

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.




