Need help with grand totals in pivot table

Giganews Newsgroups
Subject: Need help with grand totals in pivot table
Posted by:  Missygal (Missygal.27wntm_1147791301.3162@excelforum-nospam.com)
Date: Tue, 16 May 2006

I have several pivot tables where I am finding the average.  My problem
is the Grand totals are not looking correct for the averages.  What
could be the problem?  Thanks!

Average of Days to Issue    Sym            
Assistant    ABP    CDP    CWP    Grand Total
BKB        9        9
JMS    29    34    19    31
MEM    19    33    0    29
MLN    26    25        25
PJK    24    25        25
SCS    15    19        18
Grand Total    21    26    14    25

Average of Days Issued before RN    Sym            
Assistant    ABP    CDP    CWP    Grand Total
BKB        5        5
JMS    28    0    -10    4
MEM    31    5    14    11
MLN    35    13        15
PJK    38    8        13
SCS    27    19        20
Grand Total    32    10    -4    13

Average of Days in Rating    Sym            
Assistant    ABP    CDP    CWP    Grand Total
BKB        9        9
JMS    6    7    2    6
MEM    8    13    6    12
MLN    31    4        6
PJK    14    5        7
SCS    4    5        5
Grand Total    10    7    3    7

Average of Days to Quote    Sym            
Assistant    ABP    CDP    CWP    Grand Total
BKB        -26        -26
JMS    6    16    11    14
MEM    11    18    0    16
MLN    20    24        23
PJK    17    11        12
SCS    7    17        15
Grand Total    12    17    9    16

Average of Days Quoted before RN    Sym            
Assistant    ABP    CDP    CWP    Grand Total
BKB        40        40
JMS    50    19    7    23
MEM    38    19    14    23
MLN    41    14        16
PJK    46    24        28
SCS    38    21        24
Grand Total    42    19    8    23

Count of Policy    Issued less than 14 days before RN            
Assistant    Yes    Grand Total        
BKB    4    4        
JMS    30    30        
MEM    42    42        
MLN    43    43        
PJK    37    37        
SCS    41    41        
Grand Total    197    197        

Count of Policy    Qt less than 14 days before RN            
Assistant    Yes    Grand Total        
JMS    14    14        
MEM    6    6        
MLN    26    26
PJK    6    6
SCS    26    26
Grand Total    78    78

% of Accts Quoted > 14 days before RN        
BKB    100%    
JMS    70%    
MEM    91%    
MLN    64%    
PJK    92%    
SCS    63%    
Total    77%

--
Missygal
------------------------------------------------------------------------
Missygal's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=33200
View this thread:http://www.excelforum.com/showthread.php?threadid=542528

Replies