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 all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context andβ¦
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-yearβ¦
