Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: psandhya408 on 17 Sep 2013 10:51:56 AM

Title: Find the total and display at the top of the list
Post by: psandhya408 on 17 Sep 2013 10:51:56 AM
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
Title: Re: Find the total and display at the top of the list
Post by: calson33 on 17 Sep 2013 12:47:22 PM
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.
Title: Re: Find the total and display at the top of the list
Post by: Satheesh on 19 Sep 2013 02:32:43 AM

Hi,



By Using Headers you can do like that.
Text only | Text with Images