COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: ranne_78 on 10 Jan 2008 07:59:35 AM

Title: count
Post by: ranne_78 on 10 Jan 2008 07:59:35 AM
How to perform a count for a column based on another two columns in one data item.

Let's say I have 3 data items Student,subject,section

I need to calculate distinct count for  student who is taking particular subject from  those many number of sections. But in our report we r showing calculated item having  distinct combinations of student taking  subject frome those  sections. we r not populating these three dataitems (student,subject,section)

any ideas please

Thanks in advance