I created a table based on a result set with two dimensions and a numerical value. I have sorted the result set descending based on the numerical value.
When turning on the auto-pivot feature, the columns and rows are sometimes sorted based on the numerical value (e.g. cells with the highest 'heat' in the top left corner) which is the expected behavior, but sometimes the rows get sorted alphabetically, descending? I can't reproduce when this happens.
Can I fix this behavior?