Pivot Table Grand Total

Hi All,

I need some help.

I have a pivot table (see attached image) which has the dates in columns A and B, and the Company names in the columns to the right of that. The last column in the Pivot Table is the Grand Total.

Now, is there a way to place a Grand Total Column as the third column (column C)?

Any help would be greatly appreciated.

Thank so much!!

Thanks so much for your reply. Your method worked, but I needed the Company Names to also remain as columns. Here's what I ended up doing. I am hoping that it works ok.

Basically, I:
1. Created a second Pivot Table (in the same worksheet) that contained only three columns (Years, Event Date, and Grand Total)
2. Took out Grand Total column in the original Pivot Table
4. Hid the first two columns from the original pivot table