How to change order of columns and rows in the report?

mdx

#1

In the report columns and rows, Measures are arranged in the same order as they were added to the report. In columns, you can change measure sequence at any time by dragging and dropping them.

The sequence of dimension members (statuses, issue types, sprints etc) is set automatically. To reorder them, use one of the following options.

  1. Bookmark dimension members and then add them to the report one by on in the needed order.

  2. Create a calculated member in this same dimension with correct member order, then use this calculated member in the report instead of All level member.

One option is adding members in the Aggregate function in needed sequence. For example, to rearrange statuses based on the status workflow:

Aggregate({
 [Status].[Backlog],
 [Status].[Selected for Development],
 [Status].[In Progress],
 [Status].[Done]
})

You can also order members by some property. For example, order Sprints by Sprint completion date:

Aggregate({
 Order(
  [Sprint].[Sprint].Members,
  [Sprint].CurrentMember.get('Complete date'),
  BASC)
})

Customize order of Columns
Ability to Order the Transition status in a report
#2

Check out this short instructional video how to rearrange transition statuses based on the status workflow:


Ability to Order the Transition status in a report