to display branch,Result corresponding to max(sort) in each branch

[#1]

Hi I have script as follows:

t1:

LOAD * INLINE [

    Branch Name, Result, Month, Year ,sort

    BRADLEE, Pass, Jun-2015, 2015, 3

    BUCKINGHAM, Pass, May-2015, 2015, 2

    BUCKINGHAM, Fail, Jun-2015, 2015, 3

    DUKE STREET, Fail, Apr-2015, 2015, 1

    DUKE STREET, Pass, Jul-2015, 2015,4

    LANDMARK, Pass, May-2015, 2015, 2

    RIVERSIDE PARK, Fail, Apr-2015, 2015, 1

    RIVERSIDE PARK, Pass, Jun-2015, 2015, 3

    SEVEN CORNERS, Pass, Jul-2015, 2015, 4

    SOUTH ARLINGTON, Pass, Jun-2015, 2015, 3

    SOUTH ARLINGTON, Fail, Jul-2015, 2015, 4

];

i need to display branch,Result corresponding to max(sort) in each branch.

help pls...

[jonathandienst · Accepted solution]

In a table with Branch as a dimension:

     =FirstSortedValue(Result, -sort)

[MK_QSL]

=FirstSortedValue(Result, -sort)