I have a pie chart with two dimensions and an expression which is the total of the two dimensions. I want to sort the expression in descending order but I'm unable to do so. Is there a way to sort by an expression when you have dimensions? I'm thinking I have to include the sort option within the expression as you would when writing a SQL statement (i.e. ORDER BY column_name DESC).
On the Sort tab of the properties window you should be able to choose the option Expression and then enter an expression. The results of the expression will be used for the sort order.
On the Sort tab of the properties window you should be able to choose the option Expression and then enter an expression. The results of the expression will be used for the sort order.
