View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default 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