Sorting members in BI Viewer

[DDrider]

I have a BI Viewer grid using 4 accounts. When I use these numbers in a grid or pivot chart, they can only be sorted alphabetically, or ascending/descending by the data. I would like to manually sort these numbers.

E.g. My accounts are Automotive Expenses, Operating Expenses, Non-Operating Expenses and Total Expenses. I would like to sort it as: Operating Expenses, Non-Operating Expenses, Automotive expenses, and Total Expenses. 

Is this possible? Thank you in advance.

[JackLacava]

You can do it by creating a custom Calculated Field that will manage the order, adding it to a column, and then hiding the column as much as possible. The field will have to be set as Dimension type to enable fixed sorting.

Easy when you know how 😅