Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: marzbuzz on 25 Oct 2017 05:25:28 PM

Title: grand total for report with page set
Post by: marzbuzz on 25 Oct 2017 05:25:28 PM
Hi all,

I have a list report using department as page set. I want to show the grand total for gross wages so I added overall footer in the list. However the grand total is calculated against each department instead of all departments.

Please suggest.

Thanks,
MB
Title: Re: grand total for report with page set
Post by: hespora on 26 Oct 2017 02:23:55 AM
Add a new page without page set. Insert your data without Department query item.
Title: Re: grand total for report with page set
Post by: marzbuzz on 26 Oct 2017 07:56:40 AM
Thanks Hespora. I need to show both department and grand total for gross wages. For each page, I want to see the department total and for the last page I want to see both department total and grand total.

MB
Text only | Text with Images