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, is there in Anaplan the possibility to retrieve current time (date and time)? I know that now this is possibile only via integrations, but I will need to know if there is a native function.
Does anyone also get this error when opening the Forms in Anaplan FCR? I am downloading Investment Registry from the app but I cannot open it in Anaplan XL. How did you fix this issue?
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
