Is there a easy way to sort a Stacked Column chart by the aggregate value of the stacked columns? Currently, the Sort options only shows the individual columns that make up the stacked column.
The workaround I know is to convert to table, create a formula column for the total and then sort by it, but hide it from being displayed. I'm hoping there's a more direct way to do this.