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

count sectioned column

Started by Cognos Talk, 19 Feb 2016 11:32:25 AM

Previous topic - Next topic

Cognos Talk

Hello!
I need to count the sections like

1 Client Female
Jane Smith
dob, address, city
Jane Doe
dob, address, city

2 Client Male
John Smith
dob, address, city
John Doe
dob, address, city

How can I do that, the regular row number does not work
I also tried to create a manual count and placed it on the section itself   running-count(count(rows) at my_column) but it didn't work
Can you help?
Thank you,

BigChris

Do you need something link count([UserName] for [Gender]) ?

Cognos Talk

lets say i have a sectioned date and then i have a subsection with another date and detailed information below.
this detailed information can have 1-many rows, which i don't want to count, but want to do a running count on the main top section, like 1,2,3 on the section itself, skipping actually the rows with sub-section and details.
thank you

BigChris

Did you manage to experiment with that suggestion I posted earlier? Did it give you any results?

Cognos Talk

thank you for the suggestion, i tried but got a java error, maybe  because it is on the section level itself
running-count(1)  works, but it does not count what i need, it counts the rows inside the section