View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_8_] Roger Govier[_8_] is offline
external usenet poster
 
Posts: 376
Default Pivot table grand total location

Hi Rosemary

Grand Totals can only appear at the far right or bottom of Pivot Tables
--
Regards
Roger Govier

Rosemary wrote:
Is there a way to show the grand total column in a pivot table next to the
selected fields? Right now, my pivot table shows the grand total in the
right most column of the pivot table