I selected data, then clicked "view data" and was able to choose the column by which to sort. When I clicked on a column, an arrow appears that allowed me to sort based on that column. See picture below.
For your solution, I'm wondering if you have multiple columns (or can include the column by which you want to sort), and then sort by that column?
Please let us know if this does not answer your question.
Thank you for using Tableau!
Thanks Angie for answering, but it would be ordering the columns horizontally, for example first year, month, etc.
Thanks for letting me know. I got help from a coworker and have more information for you.
When downloading data, the sort order of the columns comes from the data source.
A workaround is to select Download > Crosstab instead of data. Crosstabs will export your data and keep the sort order of the columns you've specified.
Please let me know if you have any questions!
Hi. I have a similar problem. At Dimensions, I am able to sort the columns by Data Source Order. I hope to export the data by Data Source Order.
Two problems at "View Data" window:
1) Somehow I don't know why the "export" button is missing. (I do have 'export' button in my other project/data set.)
2) I manually sort the columns by drag and drop.
a) When the data are copied and pasted into excel, the order is still by alphabetically order
b) When I exit "View Data" and return, the order is back to alphabetically order and I have to sort again manually
Is there any way to export data by Data Source Order and retain the order when I return to View Data?
Thanks so much.