COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: khoinh on 15 Sep 2010 05:55:40 AM

Title: Add summary in list report
Post by: khoinh on 15 Sep 2010 05:55:40 AM
Hi,

   I am working with List report in Report Net of Cognos 8.4. I created one list report. My list report had 3 columns which are level1, level2, number. They are data item which is come from my Query. Level 1 is parent level of level 2 (it means one node in level 1 had many node in level 2). Number is data of level 2. I want to add the summary row (Total of number column) for each node of level 1 in report. I selected my list report is group by level 1 column. After that, I selected the number column and add Aggregate/Total. However, the summery row only showed in bottom of my report (it means summary for all node of level 1). How can I do "add the summary row (Total of number column) for each node of level 1" ?

Thanks
Khoi
Title: Re: Add summary in list report
Post by: technomorph on 15 Sep 2010 07:36:48 AM
Hi,

Go to:
Structure > Headers and Footers > List Headers and Footers

Then:
Check  level 1 (footer)
Click OK

Cheers