# Ability to Order the Transition status in a report

**URL:** <https://community.eazybi.com/t/ability-to-order-the-transition-status-in-a-report/825>\
**Category:** Questions & Answers\
**Created:** [July 25, 2018, 4:28pm UTC](https://community.eazybi.com/t/ability-to-order-the-transition-status-in-a-report/825 "2018-07-25T16:28:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![briantaylor](https://community.eazybi.com/letter_avatar_proxy/v4/letter/b/ce7236/32.png) [@briantaylor](https://community.eazybi.com/u/briantaylor)\
**Post date:** [July 25, 2018, 4:28pm UTC](https://community.eazybi.com/t/ability-to-order-the-transition-status-in-a-report/825/1 "2018-07-25T16:28:22Z")

</div>

Have a report that shows Average Days in Status and want to order how the status are presented in the report

 ![EazyBI1](https://community.eazybi.com/uploads/default/original/1X/a2e94105a3fe57d37fdd1e7568e09c91117d7769.png)

I have tried

Aggregate({  
[Transition Status].[Transition Status].Members,  
[Transition Status].[Done],  
[Transition Status].[Cancelled]  
})

but only get a total not a list of the status

 ![EazyBI2](https://community.eazybi.com/uploads/default/original/1X/ddf0606bba06ec29e71702cd1254868e517c091f.png)

---

<div class="post-metadata">

**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\
**Post date:** [July 31, 2018, 7:10am UTC](https://community.eazybi.com/t/ability-to-order-the-transition-status-in-a-report/825/2 "2018-07-31T07:10:40Z")

</div>

Hi @briantaylor,

You are on the right track. To order transition statuses, you can define a new calculated member using function [Aggregate()](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-members#CalculatedMembers-Aggregatemembersinotherdimensions).  
Your formula has a redundant line, which should be removed:

```
[Transition Status].[Transition Status].Members

```

For more details, see this topic and short instruction video [How to change order of columns and rows in the report?](https://community.eazybi.com/t/how-to-change-order-of-columns-and-rows-in-the-report/30)

Best,  
Zane / [support@eazyBI.com](mailto:support@eazyBI.com)

---

<div class="post-metadata">

**Author:** ![briantaylor](https://community.eazybi.com/letter_avatar_proxy/v4/letter/b/ce7236/32.png) [@briantaylor](https://community.eazybi.com/u/briantaylor)\
**Post date:** [July 31, 2018, 2:13pm UTC](https://community.eazybi.com/t/ability-to-order-the-transition-status-in-a-report/825/3 "2018-07-31T14:13:12Z")

</div>

Zane

I have the following

Aggregate({  
[Transition Status].[Done],  
[Transition Status].[Cancelled]  
})

but still only get a single line not a list of just the aggregated issues

 ![EazyBI%2014](https://community.eazybi.com/uploads/default/original/1X/f7f9c2270470766c7e35a1ab597fb8fd9cbcf8e8.png)

---

<div class="post-metadata">

**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\
**Post date:** [July 31, 2018, 2:59pm UTC](https://community.eazybi.com/t/ability-to-order-the-transition-status-in-a-report/825/4 "2018-07-31T14:59:13Z")

</div>

@briantaylor you see only one bar chart because you have not expanded the aggregated member “Transition Status Order” to see transition statues it is composed.

1. Switch to the **Table** view
2. Expand “Transition Status Order”
3. Remove “Transition Status Order”
4. Switch back to the **Bar** view.

On topic [How to change order of columns and rows in the report?](https://community.eazybi.com/t/how-to-change-order-of-columns-and-rows-in-the-report/30/2) is a short GIF showing how to do this.