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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Keep count for unique ID throughout sectioned report

Started by jpatton, 13 Aug 2010 09:36:00 AM

Previous topic - Next topic

jpatton

Hi all,

I'm having trouble using the count function to display a count of records throughout the report where that record shows up (after report is sectioned).

Example:
ID                 Business
12345            McDonald's
12345            Burger King
12345            Subway

The count of 'ID' is 3.  My report is sectioned by business, so ID=12345 will show up in each of these business' sections.  I need a column where a count of 3 shows up every time the record appears.  This let's me know the record appears 3 times in the report (no matter which business I'm looking at).

Any suggestions?

Thanks,
JP