View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Pivot Table Row Total

Hi

No, the position is fixed at the Right for Row totals and at the bottom for
column Totals.
If it is because you have a very wing or very long PT, and would like the
see the totals on screen, you could Insert a Row above your PT or a Column
to the left of the PT.

In the appropriate cells type = and point to the relevant totals and it will
generate the correct GetPivotData formula for you, to repeat the values form
the Grand Totals.

--
Regards
Roger Govier



"Robo" wrote in message
...
Using Excel 2000, am I able to show the row total in a pivot table at the
beginning of the row i.e. to the left of the data area, rather than at the
end, or right side?
--
Robo