Thanks Ashish for taking take to reply. However, the requirement is to sort the column names of underlying data. Please see comparison below and the temporary solution.
Here is tableau's sorting of column names: ascending A-Z sorting
But what the business users need to see is this order below. We added prefixes to force tableau to sort the column names. However, this is too much of manual input if we have 141 or more columns.
Hope this clarifies. Will welcome any suggestions/solution to this issue.
Mark Angelo Ruiz
I think that's the way to do it. What I have shown was at the column level sort or sheet level.
Your solution is cool. That will do the sorting at the global level. Thus we will not have to do the sorting at sheet level.
Thanks Khalid for the straight forward recommendation. However I think the issue goes beyond just by sorting by datasource. I'll give you few examples and the desired output.
As you suggested, we can sort by datasource in "source tab",
We can also sort by datasource in the left most pane.
However, when exporting to excel, it sorts alphabetically A-Z: (Product, Product Line, Product Type) vs the sorting of datasource: (Product Line, Product Type, Product).
Now, when we view the underlying data, we see the issue. Tableau sorts its own way thus the issue in export/copy.