Also, when I have a bar chart that is looking at information just from the sales data table, I am still able to sort. Just not when I've got data on the bar chart from both the sales data table and the excel spreadsheet.
Can you post a screenshot? Is the dimension from the secondary source?
Yes the dimension is from the excel spreadsheet and the sales numbers come from the sql server.
I seem to have a similar, even easier situation.
Database is MySql, have a fact table (claims) and a dimension table (participants).
For performance testing, I connected through two separate connections and established a relationship between them.
Use the participants' name from the dimension table in the row.
Use SUM( Number of Records) and AVG( Participants' Age) in the columns.
No way to sort any of this.
Using Tableau 8.1 and the documentation seems to imply that you cannot sort if a relationship is involved ... OR?