Hello, in the NUX, how can we sort time dimension (newest to oldest) when there are 2 dimensions on the row (see example) ? Many thanks for your help.
Hi @manuebilly
In anaplan directly it's not possible to sort an axis with nested dimension. How many years of data are you having?. If data is only there for 1 or 2 years you can manually reorder data in custom view.
Regards,
Akhil
I think you should be able to use the RANK function. Create a line item that ranks the date values
eg: RANK(date, descending, sequential)
and then apply the sorting to that line item.
Cheers
Alex
Hello Alejandro, thank you for your reply. I've already tried to create a line item ( item(time) ): but Anaplan doesn't allow us to sort anything on a line item when there are 2 dimensions on a a row. Emmanuelle
ah yes.
This is a maybe a bit clunky but you could create a Line Item concatenating both dimensions. Eg: Aug 14 - Cora SA
Then create a new list made of all the concatenated items.
Finally, create a new module with the new list. This new module will display all the data from the original one in a single dimension that can be sorted.
"sort" is not active
Thank you I wanted to avoid to sort many years ;)
Hi - can't access support portal having already registered. Receive the following error message - is this an issue with Anaplan or our internal IT?
Can someone help me i am unable to login anaplan portal using my credentials
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
