Hi all,
I have a widget that is built using a Full MDX. Now I would like to sort the rows by a specific column in descending order. If I sort the row elements by MDX according to the value in the cube, this takes too long because the dimension is very large.
Is there a way to sort the result of an MDX? The MDX itself is quite fast.
I found a very old post from 2017 in the forum that does exactly that, but the MDX does not work.
https://forum.cubewise.com/t/mdx-order-on-two-dimensions/754
The question comes from the fact that the initial sorting that you can set for a table in UX is no longer applied after a filter change or when you click on a row element hyperlink. However, the customer always wants the data to be sorted in descending order.
Best,
Alex