Top performance

[mambi]

Hello everyone,

step 1 : from the table below i want to get for each field the best student in it  (with the highest note) i.e : Math->Student1 and 4, History-> Student2...

Student	field	Note
Student 1	Math	9
Student 1	HISTORY	5
Student 1	SPORT	7
Student 2	Math	3
Student 2	HISTORY	10
Student 2	SPORT	8
Student 3	Math	6
Student 3	HISTORY	7
Student 3	SPORT	5
Student 4	Math	9
Student 4	HISTORY	8
Student 4	SPORT	9

step 2 : by selecting a student from the list i want to get only fields in witch he is has the highest note comparing to his friends i.e when if i select Student 1 i should have only Math, Student 4-> Math and SPORT...

any idea ?

[swuehl · Accepted solution]

Maybe like attached?

You can hide columns of the straight table chart in presentation tab as needed.

[MayilVahanan]

HI

Try like this

[mambi]

worked as i expected.

Thank's a lot.