If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to show Ranking

Started by IceTea, 12 Apr 2011 02:35:16 AM

Previous topic - Next topic

IceTea

Hi folks,

we're facing a problem that's bigger as expected. We have dimensional Data source (as for example, i rebuild the problem with the Cogosno Sample Sales&Marketing Cube). What we do want is to show the Top n in a list (or even better in a crosstab) AND show the ranking numbers.

What we did is use the "topcount"-Feature for showing only the Top N (in the following example the Top 3 "Produktreihe"). We also want to show the children of this Top 3, here so called "Produkttyp".

AND we want so show the numbers of ranking for the Top 3 Produktreihe, so 1, 2, 3 (the red numbers in the screenshot).

In the crosstab i have no idea how to do. In the list i used the Rownumber-Element, but it shows the number of every row, not just the grouped Top3-Rows.

Do you have any hint or idea how to fix the problem? Help is welcome ;)