CAn we Customise Order in MDX?

MadRacer1
MadRacer1 used Ask the Experts™
on
We can set order as Ascending or Descending.
But as per requirement in one of my project they want Display of Measure as Customised.

there are 3 columns
Direct Expenses, Overhead Exense And Revenue
i want them in order as

Revenue, Direct Expenses and lastly  Overhead Exense.

How to acheive this?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Could you add a non visible index field to your dimension table to do this?

Author

Commented:
.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial