COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: sdf on 11 Feb 2016 02:03:14 AM

Title: count members from member set rows
Post by: sdf on 11 Feb 2016 02:03:14 AM
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!