Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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% |
see attachment
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?