Sorting members in BI Viewer

DDrider
New Contributor III

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.

1 REPLY 1

JackLacava
Honored Contributor

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.

JackLacava_0-1703059474513.png

JackLacava_2-1703060033302.png

JackLacava_1-1703060009702.png

JackLacava_6-1703060764199.png

JackLacava_7-1703060778446.png

JackLacava_8-1703060806413.png

JackLacava_4-1703060147320.png

JackLacava_5-1703060170275.png

Easy when you know how 😅