If you want to sort a table calculation, you need to have a copy of the same table calculation and set it as discrete. You can drag the copy of the table calculation to View as the first dimension in Rows/Columns. The View will be sorted by the table calculation.
Let's look at an example. I will use the Superstore data for this example.
The goals for this visualization are as follows:
Here are the steps to create this visualization: