Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please find below logic which will help
Would you be able to share the sample file you are working with (if there is one)?
Consider transforming the table from a cross table to a straight table:
basically creating a table with Student, Subject, Mark fields
Then use Max(Score) / Min(Score) and FirstSortedValue(Subject, -Score) / FirstSortedValue(Subject, Score) as expressions in a table chart with dimension Student.