I have below fields. could any one help?
employee, address, case no. distance. distance is the nearest distance by employee.
i used aggr(distance, employee) and result is as below.
my expected result as below in table chart.
this expression should work for you
Thanks but i have one problem, i found No.2 employees distance is zero, then
how can i get the second nearest distance record when nearest distance is zero?