I want to sort rows and columns by values (not fieldnames). One way to do that is like it's done by DevExpress (https://demos.devexpress.com/ASPxPivotGridDemos/OLAP/Browser.aspx). By right clicking a field i can choose for with field, row, column and measurement i want to sort. But even this solution could be more userfriendly. Another more direct solution would be to sort by clicking on a measurement field or if there is only one, on a fieldname. Both are just suggestions. But the functionality of sorting by values is really relevant. http://www.telerik.com/forums/sort-rows-and-columns-by-values
Hello Alexander,
I am afraid that this functionality was postponed for implementation in a future release and is not available in R3 2019.
Regards,
Viktor Tachev
Progress Telerik
I have seen this in roadmap... (See picture attached)
And what has happened next?
the fact that this isn't already implemented is astounding.
Current link: https://demos.devexpress.com/MVCxPivotGridDemos/PagingAndScrolling/Paging
Sorting by (aggregated) measure values is pretty important functionality. It is achieved by replacing the dimension with something like ORDER(dimension, measure, DESC) in the MDX.