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 members from member set rows

Started by sdf, 11 Feb 2016 02:03:14 AM

Previous topic - Next topic

sdf

Hi,

have a  crosstab.
I have a row dataitem which is a member set from topcount.
Now, members of my topcount have members as well.
I need to return the count of this members as total in column.

top5/rows
Head1
Head2
Head3
Head4
Head5

where
head1
     body1
     body2
head2
     body1
     body2
     body3
head3
     body1

In the column must refelect the counts
             count
head1     2
head2     3
head3     1


please help!