1 of 1 people found this helpful
In Tableau, we sort Dimensions BY a Measure -- so you'd want to Sort your City dimension BY Sales. However, you are currently displaying Row-level (disaggregated) Sales, and we cannot sort based on non-aggregated measures.
If you instead were displaying SUM(Sales) and were to sort based on that measure, you'd end up with something like:
But I'm not exactly sure what you're hoping to achieve through the Table Calculation filter (or whether it was accomplishing what you hoped it would). I hope this helps you understand a bit more about Sorting in Tableau -- with awareness of this, and an understanding of what you hope to acheive as an end-result in Tableau, it will enable you to produce the output you need in the view.
See also: How to Sort Data (Computed Sorts)
Can you mock up and explain your expected results?
Thanks for the reply. My kind of problem is, I want to first find out the maximum value of third column(Here profit) and then find the corresponding second column value( here sales). I am able to achieve it. After doing that, I want to sort it using sales.
For eg, from the above submitted worksheet, I will want to sort by 100119.16, 45737.36, 36532........ and their corresponding cities.
Is that not possible here?
I think you need to create a packaged workbook. (FILE -> "Extract Packaged Workbook".) Then upload the .twbx file you get out of that.
But I think your issue is that you want to sort by a table calc.
See this article: