Print Page - how to show minmum three records in the list

Title: how to show minmum three records in the list
Post by: Gyana on 23 Apr 2012 11:32:34 PM

Hi ,
How to show the first 3 record.I have one data item & one measure.Measure column is sort in asc.I want to show only 1st three minimum value.

Data Item Measure
------------- ---------------
A 10
B 10.5
C 11.7
D 13
E 14.8
F 15
........
........
I want only A,B,C data.
So will i do,Please guide me.

Thanks in Advance.

Title: Re: how to show minmum three records in the list
Post by: Gyana on 24 Apr 2012 12:13:24 AM

Hi,
I also use Rank and filter it .Rank(measure)<3.
But it returns only one records.

Please Help me out.

Title: Re: how to show minmum three records in the list
Post by: Lynn on 24 Apr 2012 08:48:42 AM

Try setting the applicaton property of the filter to "After Auto Aggregation"

Title: Re: how to show minmum three records in the list
Post by: Gyana on 24 Apr 2012 11:34:12 PM

Thanks a lot Lynn..

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Gyana on 23 Apr 2012 11:32:34 PM