If you are unable to create a new account, please email bspsoftware@techdata.com

Author Topic: Page totals  (Read 914 times)

niahanth

  • Guest
Page totals
« 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

Offline Vamsi@123

  • Associate
  • **
  • Join Date: Dec 2022
  • Posts: 4
  • Forum Citizenship: +0/-0
Re: Page totals
« Reply #1 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 .

Offline dougp

  • Statesman
  • ******
  • Join Date: Jul 2014
  • Posts: 814
  • Forum Citizenship: +30/-1
Re: Page totals
« Reply #2 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.

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 11,567
  • Forum Citizenship: +674/-10
  • Cognos Software Muppet
Re: Page totals
« Reply #3 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.
Meep!