I made a line chart with race info of a Swimming race. There are lines for all 8 swimmers in the race and the red line is my selected person.
Cseh's line is not plotted as top line, all other lines are plotted above the red one. I can change the sortation from Page at the top to Cseh at the bottom, which gives me this view.
However I don't like this sortation to the right. I want my selected swimmer on top and the rest can be sorted by their Rank. Does anyone have an idea how I can choose which line has to be on top without changing the sortation on the right.
Thanks in advance!
Hmmm...I'll have a think. I have used FirstSortedValue() to dynamically create multiple expressions in a particular order before which worked pretty well, but you had to create enough expressions to deal with the maximum number you'd need.