Excel will insert three rows between the last two rows. This method is quick and easy, but it works differently. Specficially, Excel inserts rows below and to the right of the selected row or ...

This next step seems counterproductive, but remove the new row at the bottom of the PivotTable: 1. Select and then right-click the Grand Total row, the last row in the PivotTable.