Selecting top 3 frequency count values in script:

[#1]

Hi all..

I have a field. I want to make new field in script with only top 3 values of that field.

Plz Help..

Thanks in advance...

[#2]

Try this:

A:
LOAD Name,
     ID,
     Region,
     Value
FROM

(ooxml, embedded labels, table is Sheet1);

B:
Load
Value as topValue,
recno() as recordno
resident A order by Value desc;

😧

Load

topValue as test

resident B where recordno <=3;

[suniljain]

If you want do at design level just see following similar king of example.

If(count( aggr(NODISTINCT Count(Mobile), Mobile )) >=3   ,count( aggr(NODISTINCT Count(Mobile), Mobile )))