I am attempting to add .NumberFormat = "0.00%" to one particular cell of a pivot table: The Grand Total row of the % Spent column.

I was trying this:
Please Login or Register  to view this content.
But this selects the area ABOVE the grand total, not the actual grand total row.

How can I change the above code to apply the desired formatting to the Grand Total row?