Rank Help!

[dmohanty]

H All,

I have a chart like this below. I want to show the Bottom 5 from this. How can this be done using Rank Function?

Can the same be done using Dimensional Limits?

Please help!

ID	Value
30502113A	4.55%
REUSE-11-2MQ	5.56%
73910	5.56%
73211	5.88%
105353	6.25%
30502111SA	6.67%
01690-300	7.14%
30503-014A	7.69%
30506-10A	7.69%
79920	7.69%
DS45-11	8.33%
PORT-1	8.33%
52400	8.33%
58010	8.33%
4800-60	9.09%
30506-19A	9.09%
ARDEN-S2BK	9.09%
30506-13LA	10.00%
REUSE-09-1HP	10.00%

[maxgro]

see attachment

[dmohanty]

Hi Massimo,

Many thanks for the help.

Infact wanted to tell that this Value field is calculated from an expression like below:

=Count(DISTINCT{<[PO Line On-Time] = {'Y'},[Supplier Material Number] = {"=Rank(Count([PO Doc - Item]))<=5"}>}[PO Doc - Item])

/

count(DISTINCT{<[Supplier Material Number] = {"=Rank(Count([PO Doc - Item]))<=5"}>}[PO Doc - Item])

So, when I am applying Rank function here, it doesn't takes the Smallest 5, rather it takes some Random 5 in between.

Any issues in my expression?

If I store this expression in a variable and try to Rank it....Will that help?