Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: katdbc on 31 Mar 2011 01:43:34 AM

Title: how to obtain top 10 results from each grouped products
Post by: katdbc on 31 Mar 2011 01:43:34 AM
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.
Title: Re: how to obtain top 10 results from each grouped products
Post by: katdbc on 31 Mar 2011 10:49:47 AM
Can somebody help me please.Im badly running out of time.
Title: Re: how to obtain top 10 results from each grouped products
Post by: kattaviz on 31 Mar 2011 11:56:33 AM
Hi,

See the following link.

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

HTH
Title: Re: how to obtain top 10 results from each grouped products
Post by: katdbc on 31 Mar 2011 01:08:44 PM
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.
Text only | Text with Images