Firstsortedvalue issue

[kkkumar82]

I want to know the Student who got the minimum mark.

I was able to get expression to get the minimum mark for each subject but I was trying to get expression who is the student who secured this but my firstsortedvalue expression is not returning this.

PFA a file where I am trying this.

[Or]

Assuming you want to add this to the list of subjects:

FirstSortedValue(Student,Marks)

[kkkumar82]

The way you gave is correct but I want it in the pivot table which I am trying

[mikaelsc]

FirstSortedValue(Student,aggr(-sum(Marks),Student,Subject))

[arvind1494]

FirstSortedValue(Student,-aggr(min(Marks),Student)

[kkkumar82]

This is not working its returning only values for some of the rows

[kkkumar82]

Hi Sunny,

Can you please look into this.

stalwar1‌

[sunny_talwar · Accepted solution]

Try this

Firstsortedvalue(Total <Subject> Student, Aggr(Sum(Marks), Student, Subject))