Excel Pivot Table Grand Total Shown As First Column 1

[SgtJarrow]

Anyone know if it is possible to show the Grand Total column for an Excel pivot table as the first column on the sheet?

One of my pivot tables is about 135 columns long and the end consumer would like to have the Grand Total column shown at the beginning instead of the end. I have searched here and the web and can't find an answer.

Thanks for any suggestions you might be able to give me.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[GlennUK]

You could have a column of formulae there to fetch the values from the Grand Total column.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[SgtJarrow]

That worked for a good fake....thanks so much.

I shifted the pivot table one column to the right and created the Grand Total column before the table...Was hoping for something a bit more dynamic - as this requires me to create the first formula and then drag it down the column. But it at least meets the request at this time.

If anyone knows a dynamic way, feel free to add it in.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer