Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this
Firstsortedvalue(Total <Subject> Student, Aggr(Sum(Marks), Student, Subject))
Assuming you want to add this to the list of subjects:
FirstSortedValue(Student,Marks)
The way you gave is correct but I want it in the pivot table which I am trying
FirstSortedValue(Student,aggr(-sum(Marks),Student,Subject))
FirstSortedValue(Student,-aggr(min(Marks),Student)
This is not working its returning only values for some of the rows
Try this
Firstsortedvalue(Total <Subject> Student, Aggr(Sum(Marks), Student, Subject))