Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Excel
123quattro
charting
crashesgpfs
datamap
excel
interopoledde
links
misc
newusers
printing
programming
querydao
sdk
setup
templates
worksheet.functions
  
 
date: 13 May 2005 02:32:18 -0700,    group: microsoft.public.excel.datamap        back       


Position of totals in Pivot table   
Is it possible to have the totals of a row before you see the actial
details in a Pivot table?
eg.
in stead of
Name   Jan   Feb   Mar   Total
Joe     4     5     3     12

I want
Name   Total   Jan   Feb   Mar
Joe     12      4     5     3
date: 13 May 2005 02:32:18 -0700   author:   unknown

RE: Position of totals in Pivot table   
Hans

You should be able to just drag the total field from the right hand side to 
any column position you choose. Click and drag "Total" to your desired 
location.

Best regards
Ashley
http://vbanut.blogspot.com


"hans.wittoeck@gmail.com" wrote:

> Is it possible to have the totals of a row before you see the actial
> details in a Pivot table?
> eg.
> in stead of
> Name   Jan   Feb   Mar   Total
> Joe     4     5     3     12
> 
> I want
> Name   Total   Jan   Feb   Mar
> Joe     12      4     5     3
> 
>
date: Sun, 22 May 2005 11:49:40 -0700   author:   Ashley Bragg

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us