I searched and couldn't find an answer.
I need to sort a tabular table by subtotal as shown in this screenshot.
Also, is it possible to sort within the subtotals, like by DRG, then by Unit Cluster, then by Unit?
Attached is sample workbook.
To first get your subtotals in the desired order, right click on DRG on the rows shelf and select Sort... Then, choose Descending, Sort by Field-->Cases Sum. Click OK.
Then, if you want to further sort, a nested sort will be your best option. The following KB will provide further information on this:
Hope this helps!