12-19-2023 01:15 PM - last edited on 12-20-2023 02:58 AM by JackLacava
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.
12-20-2023 03:17 AM - edited 12-20-2023 03:27 AM
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 😅