Pivot Tables and column totals

[jonh]

Hi,

Is it possible to move the column totals from the right to the left hand side of the data (columns) being totalled?

Likewise, I would like the grand total to appear next to the 'row area' rather than to the extreme right.

 

[Richard Schollar]

Hi Jon

I do not believe that is possible (at least not in xl2003, anyhow). You could maybe implement a workaround by using 2 pivot tables and hiding the columns that you don't want to see (if you based one PT off of the other, then they would both update at the same time), but that imposes retrictions on the use of the PTs (flexibility would be lost).