Moving grand total columns in pivot table
 

Hi,
I would like to have both the horizontal and vertical grand total columns in
my pivot table to appear at the top line and left hand line respectively. At
the moment they are at the bottom row of the table and the furthest column to
the right, meaning I have to scroll to see either of them.
I have only managed to move and sort the actual data columns around, but not
these total columns.

Thanks

Moving grand total columns in pivot table
 

The position of the Grand Totals in a pivot table can't be changed.


Fil wrote:
Hi,
I would like to have both the horizontal and vertical grand total columns in
my pivot table to appear at the top line and left hand line respectively. At
the moment they are at the bottom row of the table and the furthest column to
the right, meaning I have to scroll to see either of them.
I have only managed to move and sort the actual data columns around, but not
these total columns.

Thanks


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html