Print Page - how to display top ten records in report

Title: how to display top ten records in report
Post by: inu on 25 Feb 2014 11:43:46 PM

HI
I have used rank(amount_sold), which displaying the records with ranks, but i need only top ten records. Though i tried rank(amount_sold)<=10. and even
I used the running-count(rank)<=10 function but didnot succeed.
Please guide me how to solve this problem.

Regards
Inam

Title: Re: how to display top ten records in report
Post by: Francis aka khayman on 26 Feb 2014 12:02:40 AM

your filter should be after auto aggregation or a summary filter... just try each one

Title: Re: how to display top ten records in report
Post by: mitwa on 26 Feb 2014 04:00:42 AM

HI,

just create date item --> rank ([Revenue] desc)

then give fliter as dataitem<=10

Title: Re: how to display top ten records in report
Post by: MFGF on 26 Feb 2014 05:21:51 AM

The important point - as said by khaman - is to set the filter to be "after aggregation"

MF.

Title: Re: how to display top ten records in report
Post by: mitwa on 26 Feb 2014 05:28:58 AM

ya u have to

Title: Re: how to display top ten records in report
Post by: inu on 26 Feb 2014 11:53:38 AM

Hi
Thank u guys, u helped me, now i want to display the rank of a particular country. Such as india comes in rank=8 . i want to see that rank, because i dont know india's rank.
Could you plz help me out.

Thanks
Inam

Title: Re: how to display top ten records in report
Post by: Francis aka khayman on 26 Feb 2014 09:56:34 PM

duh huh?!?!? :o just put the data item with rank(amount_sold) in one of the columns in your report

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: inu on 25 Feb 2014 11:43:46 PM