Ranking

building reports webintelligence
1

Hi All,

I created 2 variables to dispaly only the top Product Number based on the Revenue.


Ranking :   =Rank([Revenue];[Product Number];Top) ForEach ([Product Number]) 

Top 10 (In Report it's renamed as Product Number)  : =[ProductNumber]Where([Ranking]<=10)

The above formulas looks good and working fine.

The issue is when I try to bring the Customer Name in the table block then the table is expanding.

I want to display only the customer Names related to Top 10 (In Report it’s renamed as Product Number). I don’t want to see the remaining ones.
Ranking 1.JPG
Ranking 2.JPG

RUC :us: (BOB member since 2010-05-03)

2

Resolved.

/11/08/webi-how-to-display-others-in-country-field-based-on-rank/

Thanks for the blogs & BoB again

RUC :us: (BOB member since 2010-05-03)

3

I think this was meant to be a link to the following blog post:
http://howtobi.wordpress.com/2010/11/08/webi-how-to-display-others-in-country-field-based-on-rank/

Thought I would update as others may find this blog post relevant / helpful.

HTH,

JamieT

jamiet (BOB member since 2008-05-30)