I have a graph with [Region], [Year], [measure-sales]
I want to turn it to a stacked bar with Year on X and Region on Y. My problem is that I want to sort regions by sales.
If I turn the graph to crosstab I can order it by Sales for a column (for example, for 2009). That could work for me, but when I turn it to graph again, there is no sort.
I attach the graph.
Thanks in advance,