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