how to obtain top 10 results from each grouped products

[katdbc]

Please help me in resolving this issue.
I have 6 different products and I want to group them and list the top 10 Aged_apar_days  in each of the products.
I have db 2 data base
I used a query :topCount ([Business View].[Products].[PDT],10,[Business View].[APAR Drill 2010].[APAR_AGE])

where should i have this query.
I am not able to think straight and havent come across this situation since I am a beginner.

Can some body help me with the  process to implement this.
I have basic report with grouped products with all Aged_apar_days and now how should i cut it to  top 10 in each products.

I have attched the model report on how it should look

Thank you so much cognoise members.

[katdbc]

Can somebody help me please.Im badly running out of time.

[kattaviz]

Hi,

See the following link.

http://cognosibm.blogspot.com/2008/11/top-5-and-ranking.html

HTH

[katdbc]

Hi sathish,

Thank you so much for the suggestion.
this is just given for single product.
I have five different products and how to pick top 10 revenues  for each of those products.

how does topcount() works.