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.
Bookmarks