nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Sort when there are 2 dimensions in row

manuebilly

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

Questions related to Charts
Hello All, Is possible to Data label colours based on Legend? By default the Axis in ANPALAN steps up by 2.5K, how to manually adjust? Data labels for all legends is not displayed, possibly due to size, how to move the labels TIA
Reverse Lookup for a List to List Mapping (more than one mapping)
Hi, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a list…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
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…