There is a difference between Pivot Table and Straight Table Sorting...
In Pivot Table, You need to sort by First Dimension and then 2nd Dimension....
you have to sort it first according to the first dimension, then according to the next, etc. You cannot sort it any way you want.
Sorting Example.qvw 189.5 K
Thank you for your response. I will mark your response as the correct answer because you found a fix to my sorting issue.
I do not fully understand your response. In my original example I did sort by the first dimension and then the second dimension. Both sorts used the same expression, but they had sorting applied in that order. The difference you pointed out is the first dimension needs to sorted by the Y-value.
Do you know what about the Y-value sort on the first dimension caused the sorting to correct?