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.
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.
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.
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.
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
I wanted to avoid to sort many years ;)