What expressions should I use to Return a list from the rows in a reference table, sorted by distance of [Location] in that reference table to a HERE() position? More specifically said, I want my user to call a list from another table and sort it based on its distance from my current location. I cannot compare against this row's key column.
Thanks
User | Count |
---|---|
16 | |
8 | |
7 | |
3 | |
2 |