how to display top ten records in report

[inu]

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

[Francis aka khayman]

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

[mitwa]

HI,

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

then give fliter as dataitem<=10

[MFGF]

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

MF.

[mitwa]

ya u have to

[inu]

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

[Francis aka khayman]

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