Moving grand total columns in pivot table

F

Fil

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing a pivot tables Grand Totals Column 1
Pivot table grand total location 1
Format column widths from one table to a separate table on same page 1
Grand Total for Rows not Working in a Pivot Table 1
I can't see Grand total rows even though the option's switched on 2
Pivot Table Column Totals - XL2003 5
Pivot Table 2007 display field only in Grand Total 0
Need the grand total pivot table filtered worksheet? 1

Top