So this is an Aggregated calc (with an LoD element), and not a Table Calc...but that doesn't change your issue!
So one way to force a sort in Tableau, is to take advantage of the way that Blue pills sort anything to it's right in Ascending order, which means the negative sorts in descending order.
So I've taken your calculation, and then created a negative version of it. I change this to Discrete (Blue) and pop it to the left of the thing I want to sort, and voila (you can then hide the header)
Hope that helps.
Because of the LOD formula on sales you cannot. You need to use a rank function on the calculated field you created and to turn it to discrete.
The step by step explanation below:
Taking a data set of total population by country. When we simply import the data and use country name by total count of population, the visualization looks something like this
Showing this data as it it will not make any sense for the end user. As a problem statement, we want to see which country has the highest count of total population and so on. To achieve this we will try to sort this data in descending order
Once you have clicked on the sorting icon, your data visualization should look something like this
Now that we have the sorted data, we would like to show the Rank of the country as well. To use the rank functionality, let us first duplicate the column data. Clicking CTRL + Selecting the column data will duplicate the column data. Final result will show us two similar visulaizations
Once you have duplicated the column data, click on the corner drop down arrow and go to Quick table calculation and then further select the Rank option.
After clicking on the rank option, your data visualization should look something like this
Now, to show the rank of the country drag down the ranked calculation to row field
If you observe here, the visualization has changed and ranked information is grouped together with the total population specific data. Although, this is the correct visualization but this will create more confusion for the end user. To make it more simpler and clear, we will be using the Discrete option.
After using the discrete option, the final visualization should look like this
Hope this helps,
Thanks that works.