Print Page - Rank a List Table with Section

Title: Rank a List Table with Section
Post by: reginoilano on 15 Jan 2010 03:18:42 AM

Guys,

I'm having a hard time to get the Top 10 of revenue in a list table where it has section per store.

the main goal that I need to achieve is to get all the top 10 revenue per store. this report has only one query used by the list table with a section of store.

your suggestions will be much appreciated!

Title: Re: Rank a List Table with Section
Post by: MFGF on 15 Jan 2010 04:58:36 AM

Hi,

Define a rank column as a Query Calculation with the expression rank([Revenue] for [Store])

Add a detail filter with the expression [Rank] <= 10
set its timing to After Auto Aggregation.

MF.

Title: Re: Rank a List Table with Section
Post by: reginoilano on 18 Jan 2010 04:24:20 AM

Thanks MFGF! now it's working :)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: reginoilano on 15 Jan 2010 03:18:42 AM