I'm not sure if this is the same as your setup, but the sort may not be available
due to the nature of your calculation for penetration rate, which may involve
some types of table calculations.
In the example workbook v10.3 attached in the Forum Thread, the Column dimension is a Lookup.
This similarly did not have any options for sorting.
To get the columns to sort by SUM(Sales), I put that on the Column shelf as a dimension
to the left of my LookupDimension. (I also edited it in-shelf to put a negative sign in
front the make it descending). Then I unchecked "Show Header".
If this does not match well your setup, would be grateful if you could post
the equation for penetration rate.
276614sort.twbx 1.2 MB