|MDX expression that returns set.|
|MDX expression that returns number.|
By default members are ordered by name. Aggregated set of members can be used to rearrange order in which members are displayed. For example to reorder Priority dimension and have "Low" as first member and see "Critical" after it (by default arranged alphabetically with "Critical" being the first) add Priority calculated member as follows:
Select this member and drill into to see individual aggregated members.
Another option for changing order is that you can Search and Bookmark member names of dimension that you wish to include in your report. Afterwards you can select the bookmarked columns from dimension "Select members" bookmarked members part in the order you wish to display them in chart.
Following example returns set of currently ongoing Sprints by filtering out only Sprint members that are not closed and have start date.