Forum Discussion
Column Secondary Sort Order
I have a bunch of orders, each with a status of Won, Lost or Open. All of these orders are divided by region. So I throw them all up on a Clustered Column chart, sorting by region. Great - all works....
Rather than make a new column you could just create a new table saying Won 1, Open 2, Lost 3 and then link it, then try to sort by that column?
I'm not sure how/whether that would work - my data source is actually one very long SQL statement pulling in five or six tables from the database.