I have a simple pivot table but I can only seem to sort by 1 column.
It is for jet ski racing to work out the winner. I need to sort the data first by the number of laps (descending order) and then by the total time (ascending)
here is a screen shot of what I have.
data on the left is ski number and times at which it passed the start/finish
the PT on the right is showing ski number then count(ski) then max (laptime)
I have sorted by laps but need to sub sort by max laptime