How to order by column in EazyBI report?

[Sergey Shmarkatyuk]

I tried to use following MDX query as a calculated member: "Order({[Category].[All Categories]}, [Category].[All Categories], DESC)". But I am getting following error: "Member expression 'Order({[Category].[All Categories]}, [Category].[All Categories], DESC)' must not be a set". Do you have any ideas of how could I change the query to achieve what I want? 

[Mārtiņš Vanags]

Hi Sergey,

In case you want to create a new calculated member in "Category" dimension that returns an ordered set of members, you could try the following approach:

Aggregate(
Order(
[Category].[Category].Members,
[Category].CurrentMember.Key, DESC
)
)

Please contact support@eazybi.com if you have further questions regarding this!

Kind regards,

Martins Vanags / support@eazybi.com