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

Tips & Tricks
2

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

  1. Make sure the report does not have any other order enabled, for example, order by some column.

  2. Select only calculated member with ordered values for the report. In the report, click on the calculated member name and select this to ensure it is the only member from dimension.
    At this point, you should have one column for each measure if you order columns.

  3. In the report, expand the calculated member to get custom field values in the same order as you have listed them in the calculation.

  4. In the report, click on the calculated member name (one with the minus sign in front of it) and remove it from the report. The rest of the values will remain ordered.

8 Likes