Sorting all fix-version


#1

I’m trying to create a report with alphabetically sorted list of all fix-version thru calculated field but seems not to be working out.

What am I doing wrong?

Tx!

Aggregate(
Order(
Filter([Fix Version].[Version].Members,
[Fix Version].CurrentMember.Name <> “(no version)”
),
[Fix Version].CurrentMember.Name,
DESC)
)


#2


#3

Your formula orders versions taking into account a hierarchy - particular project and status.

DESC - sorts members descending taking into account a members hierarchy. You would like to use BDESC to ignore any hierarchy and get an ordered list of all versions of any project in any status.

Aggregate(
Order(
Filter([Fix Version].[Version].Members,
[Fix Version].CurrentMember.Name <> "(no version)"
),
[Fix Version].CurrentMember.Name,
BDESC)
)

Daina / support@eazybi.com