Excel seems to know that this is a grand total and not a subtotal. This next step seems counterproductive, but remove the new row at the bottom of the PivotTable: 1.

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

In this guide, Excel Off The Grid walk you through how to build a total row that adjusts itself as your data changes, using some of Excel’s most powerful functions.From customizing calculations ...

Image: sdx15/Adobe Stock. Microsoft Excel PivotTables are a great way to summarize data. They’re easy to create and display information in meaningful ways, such as subtotals and grand totals ...

Although you can see only the totals, if you copy them now Excel will include the hidden rows. Press "Ctrl-G" or "F5" on the keyboard to bring up the "Go To" dialog box.

How to create a running total in Excel. Follow these steps to create a running total in Excel: 1. Start with =SUM. Select the cell where you want your running total to begin.

2. Determine the formulas you need for your sheet. In our example, we want to get the total number of items sold, Total Sales for each item, Grand Total Sales, and the Quota Classification.