It seems like whenever I put a hierarchy into the column category of a metric set onto a data table, dundas forces the heirarchy member names / column headers to display alphabetically. Is there a way to change the column header order?
I am using an OLAP datasource, if that makes a difference. No data cubes here.
Hi Ryan,
As per my understanding, you have a table visualization that has a hierarchy in the column section which has some default sort order and you are looking for a way to change this sort order.
If this is something that you are looking for then you can open this table visualization in view mode and then right click on the table header. Here you will get an option named “sort” in the context menu. You can then click on this option and then select the hierarchy by which you want to sort:
Followed by specifying the sort direction:
You can also specify the sorting by clicking on the filter icon present in the column hierarchy in the table’s data analysis panel:
You can also refer our support article for more details on how to sort a table visualization:
https://www.dundas.com/Support/learning/documentation/data-visualizations/how-to/sorting-a-table-visualization
Ryan, by default hierarchy is sorted in ascending order but you can change this order by either changing it to descending or create a custom hierarchy sorting by editing the hierarchy from data analysis panel. You can find more information about custom hierarchy sorting here https://www.dundas.com/Support/learning/documentation/data-metrics/define-custom-hierarchy-sorting
Utilizing the over rides worked for me. Thank you!!