Sort when there are 2 dimensions in row

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.

Accepted answers

AkhilEmmanual

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.

Screenshot 2023-09-11 5.58.02 PM.png

Regards,

Akhil

All comments

AlejandroG

Hi @manuebilly

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

manuebilly

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

AlejandroG

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.

manuebilly

"sort" is not active

AkhilEmmanual

Hi @manuebilly

Screenshot 2023-09-11 5.58.02 PM.png

Regards,

Akhil

manuebilly

Thank you
I wanted to avoid to sort many years ;)

Quick Links

Can you help?

Unanswered questions

one or multiple models
Does anyone have any documentation on the trade-offs of having 1 model for all components of planning (service revenue, product revenue, labour planning), vs multiple models 1 for each and a consolidation model to tie it all together?
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
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…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…