Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Maybe like attached?
You can hide columns of the straight table chart in presentation tab as needed.
Maybe like attached?
You can hide columns of the straight table chart in presentation tab as needed.
HI
Try like this
worked as i expected.
Thank's a lot.