I have stacked Pivot Charts where the results are displayed as 100%. I want to sort the chart so that the maximum vacant percentage (87.5%) is at one end and the smallest vacant value (18.23) is at the opposite end.
When I right click and try and sort it form the smallest to the largest percentage it wont sort correctly. I suspect it is sorting on the sum of vacant values and not the calculated percentage.
I have recommended this question be closed. A correct answer was given.
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit.