Report All Different Values

[Charles]

Hi All:

This is a reposted question.

I have a data file like:

Dept Sec q1 q2 q3 M1 M2 M3
AA 100 2 2 2 2.24 2.24 2.24
AA 100 3 3 3 2.24 2.24 2.24
AA 200 2 2 2 2.63 2.63 2.63
AA 200 3 3 3 2.63 2.63 2.63
AA 200 4 4 4 2.63 2.63 2.63
AA 300 3 3 3 3.14 3.14 3.14
AA 300 4 4 4 3.14 3.14 3.14
BB 100 2 2 2 2.24 2.24 2.24
BB 100 3 3 3 2.24 2.24 2.24
BB 200 1 1 1 2.63 2.63 2.63
BB 200 2 2 2 2.63 2.63 2.63
BB 200 3 3 3 2.63 2.63 2.63
BB 200 4 4 4 2.63 2.63 2.63
BB 300 2 2 2 3.14 3.14 3.14
BB 300 3 3 3 3.14 3.14 3.14
BB 300 4 4 4 3.14 3.14 3.14
CC 100 1 1 1 2.24 2.24 2.24
CC 100 2 2 2 2.24 2.24 2.24
CC 100 3 3 3 2.24 2.24 2.24
CC 100 4 4 4 2.24 2.24 2.24

M1 is scetion means for q1, M2 for q2, and M3 for q3. Now I need to
generate a report grouped by Dept and the report should display Dept average
as well as all section means for q1, q2, and q3. The report will look like

Report AA

q1 Section Means M1 2.24 2.63 3.14 Dept Average 3.00

q2 Section Means M2 2.23 2.63 3.14 Dept Average 3.00

q3 Section Means M3 2.23 2.63 3.14 Dept Average 3.00

How can I have all section averages display on the report for each Dept?

Thanks for any kind of help.


Charles