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 ;)
(http://www.abload.de/img/topcountranksg72g.jpg)