Forum Discussion

DDrider's avatar
DDrider
New Contributor III
2 years ago

Sorting members in BI Viewer

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's avatar
    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.

    Easy when you know how 😅