That would be a great feature, being able to sort based on a specific selection. I would recommend adding this to the Ideas section of Community.
Currently, I cannot think of a way to do this. The best I can come up with is to separate the horizontal and vertical routes onto separate sheets.
1 of 1 people found this helpful
Hi Michael, interesting map. Where did you get all the routing lat/longs? By hand using Google Maps, or did you find a database? Anyway see attached for a way to get the sorting you're looking for. Here's basically what I did:
Created this calc field and placed it on the level of detail shelf. It will mess up your routes until you change it to an ATTR(). Once you've got it there then open up your TMC9 pill on the path shelf and edit the sort. Use the new calc to sort on:
You can use min or max, it doesn't matter. (But you can't use count.) Now all your routes work, except I noticed an anomaly on the Bal-Phil route:
But the Phil-Bal route is fine.
Not sure your strategy for setting the path is ideal, but then if it works hey go with it! Hope this helps. (And I just saw Tracy beat me to the punch again, but I'll post anyway just in case this happens to be more of what you're looking for.)
I checked the twbx you attached and I like it! It is a bit more manual than I would hope... Perhaps including a column called "IsVertical" filled with boolean values, and follow this approach but based on the boolean state as opposed to a more thought out mapping would make the most sense for larger datasets of more than 6 routes. Thanks a bunch! I will be using this in the interim.