This is a question to get my mind straight on how Tableau sorts.
I have attached a simple workbook to help with answering several of my question.
Here is what the worksheet looks like:
1. Can I sort on the "Change %" (third column)? It is a Calc field. Does that matter?
2. When the percentage changes, can the fields re-sorted automatically?
I am so sorry to ask such a simple question. Just found myself chasing my tail.
Robert, the issue isn't that it is a calculated field, but that it includes a field from a secondary data source. You might try doing a join instead of a blend.