COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Cognos Talk on 19 Feb 2016 11:32:25 AM

Title: count sectioned column
Post by: Cognos Talk on 19 Feb 2016 11:32:25 AM
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,
Title: Re: count sectioned column
Post by: BigChris on 24 Feb 2016 02:06:26 AM
Do you need something link count([UserName] for [Gender]) ?
Title: Re: count sectioned column
Post by: Cognos Talk on 24 Feb 2016 05:51:59 AM
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
Title: Re: count sectioned column
Post by: BigChris on 24 Feb 2016 06:11:23 AM
Did you manage to experiment with that suggestion I posted earlier? Did it give you any results?
Title: Re: count sectioned column
Post by: Cognos Talk on 24 Feb 2016 06:51:01 AM
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