Inside the Tables group, click PivotTable. 3. In the resulting dialog, ... As you can see in Figure F, the row is gone, and the row that was above now displays Grand Total. Figure F.

Step 8: Insert a calculating form field for the grand total Now you’re ready to create a form field that will calculate the grand total. This one’s a little more complex, because you must ...