Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Size | Charts and Charting in Excel | |||
Grouping data in pivot table columns | Excel Discussion (Misc queries) | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
arranging columns in pivot table | Excel Discussion (Misc queries) | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) |