Count Function

[koolbachi]

Dear Cognos Folks,

I have a report in which I want to use count function in data item in keep 1 and property for dataitem as Count.

One scenario it works and other scenario it doesn't work:

Scenario 1:

I have four data item CD1,CD2, CD3 and Count1(Dataitem) in filter I included CD2 in 'xxx' and CD3 = 'yyy'

List is as below  seems to work .

CD1   CD2   CD3   Count1   
cc   xxx   yyy   3   
dd   xxx   yyy   4   
ff   xxx   yyy   18   
gg   xxx   yyy   25   

Scenario 02: Doesn't work as required when you see in count its only giving 1 all the rows.

The Filter in this report is CD2 in 'xxx'.

CD1   CD2   Count1
cc   xxx   1
dd   xxx   1
ff   xxx   1
gg   xxx   1


Note : CD3 is from different namespace and table.

how to get the correct count in scenario 2.

Thanks in advance

Regards
Gops