If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

how to show minmum three records in the list

Started by Gyana, 23 Apr 2012 11:32:34 PM

Previous topic - Next topic

Gyana

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.

Gyana

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

Please Help me out.

Lynn

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