I have a pivot table, with 3 dimensions and 2 measures. One of my dimension is calculated dimension and one of the measure has set analysis. I want to sort by simple expression SUM(amount) which is one of the measure. It does not work. I have encountered this many times, don't know why. How do you enforce the sorting in that case?