+2Does anyone know if I can sort the items in a filter so that my cost centers (or GL account) shows in ascending order?
I created a filter for cost center currently but all the available items are listed randomly, I tried sorting the dimension list in ascending order but it doesn’t reflect properly when I use the selectors.
Thank you!
Best answer by Chahat
Hi
If you will apply the sorting in the dimension list i.e. Cost Center list using the ‘Manage Items’ → Reorder feature, and then it will automatically show you the items in the reordered manner in the dropdown filter.
Hope this makes sense , let me know if it worked for you!
+14Hi
If you will apply the sorting in the dimension list i.e. Cost Center list using the ‘Manage Items’ → Reorder feature, and then it will automatically show you the items in the reordered manner in the dropdown filter.
Hope this makes sense , let me know if it worked for you!
+9Hi,
As a simple example:
It’d be great to sort filtered "Planning Versions" by the "Item Variable" instead of the default dimension sort. I tested a custom sort in the "Set_Filter Planning Versions" metric, but it reverts to the dimension’s sort .
Regards
JDLove
+7
+14Hi
At the moment it is not possible to do this in an easier way unfortunately. However, there is an idea submitted to have a default property for sorting. :
Hi
This will let you select the property of your List you’d like to reorder by.
However, as mentioned, this will not enable a “dynamic reordering” meaning that each time new Items are being added to the List, you will have to reorder through that method again.
I hope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
