How do I sort a list?

In excel, order the list members (members only, not parents, etc, just the members as they appear in the list in Anaplan) in the order you would like it in Anaplan. Then copy just the list members. In Settings->List->Grid View (not Tree view!) of the list, click Insert, choose Start as the ‘position’, paste in the list, click OK

Accepted answers

PrevContributor

Note that you could also achieve this by exporting the list members, copying and pasting with the above method. If your list has a composite hierarchy then you would need to set up a filter so that only those list members are that particular level are shown. This can be done in a module by the following:

- Create a module with only the dimension of the list you want to export.
- Add one line item that is boolean formatted, and set the formula to "TRUE"
- Filter where that line item is checked and export via Data > Export

All comments

PrevContributor

simon_ritchie

Hi Moritz/Ryan,

Any ideas if it's possible to sort a numbered list? On insert it just asks you how many items you want to insert, so copy/paste wouldn't work.
Could I turn it back to a general (non numbered) list, sort, and then make it numbered again?

I will try the above and post the results.

Thanks,
Simon

PrevContributor

[quote=Simon Ritchie]Hi Moritz/Ryan,

Any ideas if it's possible to sort a numbered list? On insert it just asks you how many items you want to insert, so copy/paste wouldn't work.
Could I turn it back to a general (non numbered) list, sort, and then make it numbered again?

I will try the above and post the results.

Thanks,
Simon[/quote]

Simon - did you ever figure this out?

simon_ritchie

Hi Mitch,

This is what I did:

Turn it back to a general (non numbered) list,
Use the techniques described by Moritz/Ryan above to filter out parent items and sort as needed
copy just #Number Ids
In Settings->List->Grid View (not Tree view!) of the list, click Insert, choose Start as the ‘position’, paste in the list, click OK
And then make it numbered again, remember to set the Alias to what it was previously

It's pretty manual, havent found a way to automate it yet.

Cheers Mitch, Hopefully see you again in London soon.

Simon

PrevContributor

[quote=Simon Ritchie]Hi Mitch,

This is what I did:

Turn it back to a general (non numbered) list,
Use the techniques described by Moritz/Ryan above to filter out parent items and sort as needed
copy just #Number Ids
In Settings->List->Grid View (not Tree view!) of the list, click Insert, choose Start as the ‘position’, paste in the list, click OK
And then make it numbered again, remember to set the Alias to what it was previously

It's pretty manual, havent found a way to automate it yet.

Cheers Mitch, Hopefully see you again in London soon.

Simon[/quote]

This is great! It is a bit manual and cumbersome, but it beats doing it manual any day. Thank you all!

SDahlin

There is a way to do this with a line item using the rank function. If your list has a code that is a numeric string, convert this to a value then rank it. Then apply the sort based on that rank on the lowest level of the hierarchy.

The syntax I used was RANK(VALUE(CODE(ITEM('List'))), ASCENDING, AVERAGE, TRUE), sorts hierarchy automatically

Quick Links

Can you help?

Unanswered questions

Invalid Parent - Combined List
Hello Anaplan Community, I have a product hierarchy with 5 levels . For a client requirement, I need to transform this product hierarchy into a combined list , to be able to select different levels of the hierarchy in a line item (drop down list) For this, I tried to create different saved views where I have for example :…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…