Find the total and display at the top of the list

[psandhya408]

I have a list report as shown in the below:

I have to sum up as per the subject and display on the top of the list. How can I do?
Please help.

Dept code    subject    count_students    count_teachers
                      Maths         25                       14
                      Science       36                       12
010               MAths         10                         5
020               Maths          15                        6
030               Maths          0                          3
010               Science       11                        1
020               Science       12                        7
030               Science        13                        4

[calson33]

union two queries (one for each of the groups). Have an extra column for sorting (e.g. for the overall numbers the column would be = 1 and for the by dept numbers it would be 2), and then sort by the invisible column, the subject and the dept code.

[Satheesh]

Hi,



By Using Headers you can do like that.