Amit- I don't believe Excel like sorting is possible in Tableau. You can only sort on one measure. There are workarounds using custom SQL but not sure if that's something you might want to look into and worth the effort. Please feel free to upvote this idea, and go through the responses for some workarounds.
Thank you for your response. But where can I find the responses for some workarounds?
Yuriy- Your approach is simple and interesting. Thanks for teaching me this.
Since this is a multi-level sort, you'll first want to calculate the rank for each team based on PTS. Use the "rank" calculation- rank(sum(PTS))
Make sure you choose the correct aggregation, I'm using sum in this example but change it to avg, max, min or whatever you need it to be. That will create a rank for each team as an integer and give teams with the same PTS number the same rank.
Now to add the second part of the sort for %Cal - create a calculated field that adds the rank calculation from before with the %Cal - rank + sum(%Cal)
You can then use this calculated field as your sort - it will still use the original ranks as the initial basis for sorting, but if the ranks are the same, the decimals from the %Cal will come into play for the sort.