Enforce sorting in Pivot table

[bimala0507]

Dear experts:

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?

Kind Regards,

Bimala

[Gysbert_Wassenaar]

Try the Sort by Y-value option. Enable that for the first chart dimension.