Fetch top 5 values

[GOKULAKANNAN]

Hi Team,

I need to fetch top 5 performer in class, 

My inputs are mark,subject,student

I need to fetch the top 2 students based on total marks

Load * inline 

[

Mark, Subject,student

100,maths, guru

25,maths,nagesh

35,maths,venkat

65,science,guru

75,science,nagesh

86,science,venkat

75,english,guru

76,english,nagesh

78,english,venkat]

Here i need top 2 scorers , how can i calculate it

[abhijitnalekar]

Hi @GOKULAKANNAN ,

Are you looking for below output?

[salonicdk28]

Hi 

Try this-

Dimension =Aggr(If(Rank(sum(Mark))<=2,student),student) and uncheck include null values from there

Expression =sum(Mark)

Hope you are looking for this only

Thanks,

Saloni