Figure I shows the new grand total text, sans (blank) and the Currency format in the amount field. Figure I. The finished PivotTable has three grand total rows instead of only one.