I'm trying to use the CrossTab to show the TOTAL average but it doesn't seem like it includes the "0" values.

 

for example:

 

                        2008    2009    2010    Total

A                     0          0          27.64   27.64

B                      53.89   41.71   42.11   46.32

C                     0          10.96   10.25   10.37

 

Is it possible to included the zeros in the average? i.e first row...(0+0+27.64)/3 = Total Average A