5 youngest players in a straight table

[Kohli]

I have table like

Athlete,  Age, Year, Sports

hari, 21, 2012,  swimming

Sam, 19, 2008, Kabaddi

Nara, 18, 2012, Running

Sant, 16, 2016, Jumping

Ams, 17, 2016, Swimmimg

Nar, 15, 2012, Hocky

Tej, 25, 2016, Long Jump

Uday, 15, 2012, Swimming

Kiran, 17, 2008, waliking

I want output Name, and Age.

name, Age

Nar, 15

Uday, 15

Sant, 16

Ams, 17

Kiran,17

[sunny_talwar]

May be this

Dimension

Name

Expression

If(Rank(Age) < 6, Age)
If(Rank(-Age) < 6, Age)

[lironbaram]

hi 

in a table 

dimension : Name 

expression : if(rank(total -Age)<=5,Age)

[santhiqlik]

Hi,

There are different ways to achieve this.

-If we add age as expression and it is first expression in your table then you can use Dimension limits feature as shown in the attached. Make sure to sort by age.

-If age should be in Dimension then we can use aggr in calculated dimension for Name as follows

    =If(aggr(Rank(-age) <= 5,Name)  and we should uncheck "Include Null values" to return only Top 5  youngest players