topic Re: Fetch top 5 values in App Development

Fetch top 5 values

GOKULAKANNAN — Wed, 24 Nov 2021 17:02:55 GMT

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 — Thu, 25 Nov 2021 04:32:22 GMT

Are you looking for below output?

salonicdk28 — Thu, 25 Nov 2021 09:51:03 GMT

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