Hi,
I have raport like on picture.
I need to sort date, like this:
I was try do this with this calculated member in Issue, but id doesn’t work with so many dimensions
Aggregate({
Order(
Order
(
[Issue].[Issue].AllMembers
,[Issue].CurrentHierarchyMember.get(‘Expected’)
,BASC
)
,[Issue].CurrentHierarchyMember.get(‘CRM Companies’)
,BASC
)
})
Hi Tomasz!
To do some custom ordering by concatenating several properties you can create a measure where you first have the first ordering criteria and then the second. For example, ordering by Status and then by Assignee
[Measures].[Issue status] || " " ||
[Measures].[Issue assignee]
You can add this measure and order any column by it. After this remove it and the ordering will remain
Lauma / support@eazybi.com
