Does 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!
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!
Hi,
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.