I have a field. I want to make new field in script with only top 3 values of that field.
Thanks in advance...
A:LOAD Name, ID, Region, ValueFROM[C:\Users\Administrator\Desktop\Test Reload.xlsx](ooxml, embedded labels, table is Sheet1);
B:Load Value as topValue,recno() as recordnoresident A order by Value desc;
topValue as test
resident B where recordno <=3;
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 )))
Retrieving data ...