COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: niahanth on 03 Aug 2016 09:39:15 AM

Title: Page totals
Post by: niahanth on 03 Aug 2016 09:39:15 AM
Hi All,

I have a a list report of multiple pages. At the each end of each page i need to get the total  which should only total the data present in that page. Similarly for next page i need to total for data only in that page. Can anyone help on how to achieve that.

Thanks
Title: Re: Page totals
Post by: Vamsi@123 on 20 Jan 2023 03:59:21 AM
Hi team
You need to use groupby which column you want separate page and givevpage set that column (which was group by column) then you will get page wise total .
Title: Re: Page totals
Post by: dougp on 23 Jan 2023 01:32:01 PM
Vamsi is correct.  Cognos won't give you a total based on a variable or random collection of data.  You need to define what belongs on each page, then have Cognos total that.
Title: Re: Page totals
Post by: MFGF on 23 Jan 2023 03:11:35 PM
Great replies, but the original poster is no longer around, sadly. The admins of the site cleaned out unused accounts sometime last year, and the OP's account looks to be one of them.

Cheers!

MF.