1 of 1 people found this helpful
Here are some older instructions for doing this - Nested Sorting without Combined field
The only thing different is that now the Table Calculation dialog box looks a bit different. Note that in the version you have, you will want to create a measure just for 2016 (or a parameter so you can switch between sorting by different years). I created a parameter version for you as well on sheet 3..
See Final though for a working version like the one you mentioned.
The attached workbook is in version 10.1 of Tableau. If you do not use this version yet, please download 10.1 and install to review. You can have multiple .x versions of Tableau installed at the same time under the same license.
Please mark my answer correct if this resolved the issue or mark it helpful below if it merely helped you. This enables others to locate this post and reply for similar issues when searching.