Hi,

I have a cross tab with the following:

--------------Jan --- Feb --- Mar --- Apr ---May --- Jun ---- Jul

P.Jones -------20 --- 12 --- 12 --------45 ---12 ----87 ----- 23
A.Smith -------22 --- 11 --- 77 --------56 ---43 ---- 98 ----- 86
T.Taylor -------45 --- 54 --- 21 --------21 ---98 ---- 43 ----- 54


I would like to add an average of each column in one row at the bottom of the cross tab. Sort of like a Grand Total - but an average (not total). is it possible to change the grand total to an average, or is it possible to inert just one row at the bottom of the cross tab that does this please?

This is required:

--------------Jan --- Feb --- Mar --- Apr ---May --- Jun ---- Jul

P.Jones -------20 --- 12 --- 12 --------45 ---12 ----87 ----- 23
A.Smith -------22 --- 11 --- 77 --------56 ---43 ---- 98 ----- 86
T.Taylor -------45 --- 54 --- 21 --------21 ---98 ---- 43 ----- 54
Average -------23 --- 34 --- 11---------30----66---- -34----- 54


Thanks