We have many columns in the table and sorting is enabled. Non-calculated columns are sortable (ascending / decending) by clicking on the column header. But any column containing calculated values are not sortable even though the sort functionality appears to be there, nothing happens.
Can user sort by calculated columns in a table?
There is a note in the article on Sorting a table visualization, which seems relevant. The aggregator in calculated measures is set to None by default. I think changing that should do the trick.
Thanks! Will try that and see if performance is still okay.
Updating the aggregator worked great the calculated columns now sort, however we have a dynamic hierarchy as the first column and that column shows the A-Z indicator for context sorting but does not actually sort the column when executed. does the dynamic hierachy not work with sorting?
Were you perhaps working in the Metric Set Designer? As mentioned in the Notes section of the article I mentioned above, sorting features are not available in the Metric Set Designer when using a Dynamic Hierarchy. However, you can use them when in the View mode of a dashboard using this metric set.