Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try the Sort by Y-value option. Enable that for the first chart dimension.