how to sort a column by other column which is not used in the visual, when connected to live dataset

[newtopbidax]

I know there are multiple posts on how to sort the matrix visual using 'Sort by Column'. But I work with the reports that are connected to the live dataset. Even if I create the sort order in the dataset level, how can I use that column to sort the columns of my matrix live report?
It's sorting alphabetically by default but I don't have an option to change that.

[Greg_Deckler]

@newtopbidax You would have to configure the Sort By column in the source dataset.