Nested Sort - per multiple columns

[ran.lavi]

Currently EazyBI tables allows sorting only per one column.
Sometimes it is required to do a nested sorting: Sort per one column, and then a secondary sort per another column.
We would appreciate adding this to your backlog.

[daina.tupule]

Hi Ran

We added the request to our development backlog.

[frajus]

Hi guys, we also are interested in this feature. Is there a chance that it will be implemented or is there a workaround to achieve this? Thanks.

[Racquel_Burton]

We are also interested. Any plans to add this?

[Melissa_Martin]

Any update on this? This seems like a really valuable feature.

[HugoVarandas]

Any workaround to make a nested sort?

[zane.baranovska]

This feature is still on our backlog.
The workaround is a calculated measure that could be used for ordering. Here are few examples:

How To sort by 2 Columns, One ASC and the other DESC

Hi, Try this formula when creating a new calculated measure: Cast([Sprint].CurrentMember.Name as string)||" - "|| Cast( Rank( [Sprint].CurrentMember, Order( [Sprint].[Sprint].Members, [Measures].[Sprint end date], BASC ) )as string) Then sort your report by this new calculated measure in descending order. Finally, you could click on the column and remove it. The sorting must remain in the report Martins / eazyBI team [sorted by sprint name and end date]

Order by First Row

Hi everybody! I have table with two dimensions: “Impacted Features” and Time. The time dimensions is also a page, in order for it to be selectable. The problem is: I want to order the table by “Impacted Feature”. When I try to sort itthe impacted features get jumbled as only Time is sorted: [image] (see how the “Impacted Feature” “CM: Search and filters” is repeated by quarter) Ss I want to keep the agregation by “Impacted Feature”, like this: [image] while ordering the sum of it’s valu…

Best,
Zane / support@eazyBI.com