top10 with filter

[jacknjill]

help anyone.

i am using a cognos8.1 version
data source type dimensional package

i am creating a report that will show the top 10 products based on delivered qty, this will also show details such as sales amount and ranking by qty and amount.

management wants to exclude a certain product from the top 10

i was able to use the rank syntax but when i add in the filter to exclude that certain product it returns no record.

i have tried the topcount and exclude the specific product using the filter and it work well, but i cant seem to add the ranking by qty and amount.

been trying to figure this one out for almost a week.

[rockytopmark]

TopCount() function will do the trick for you, and embed the filter() function inside the TopCount() to limit the rows.

Online Help and doc on these functions is very good.