Sorting of list when used as line item

Contributor

Sorting of list when used as line item

Hi,

I need to change how list hierarchies are sorted when used as format for a line item. See image below;

Anaplan sorting issue.pngIn this case, I have 2 lists, where the ones named "Parent" are L1-level and "Child" L2-level.

As shown in the images, the child are above the parent. I want it to be the other way around. Does anyone know how to do that?

Any help is appreciated!

Best,
Fredrick

Message 1 of 8
7 REPLIES 7
Community Boss

Re: Sorting of list when used as line item

I don't think that is possible (idea exchange?)

A workaround would be to use a dependant drop down so that the users chooses a parent and then only the children will show in the drop down

 

Do you need the parents to show at all?

If not, you could create a flat list of children, get the users to choose those and then map them back to the hierarchy

 

David

Message 2 of 8
Contributor

Re: Sorting of list when used as line item

Hi David,

Dependent drop-down could be a solution. How would I do that? Sorry but I have never worked with dependent drop-downs before...

/Fredrick

Message 3 of 8
Community Boss

Re: Sorting of list when used as line item

Sure

This is actually one of the easier dependent drop downs to create

https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Dropdowns/Many-to-many_Filtered_Pi...

Gives a lot more examples - You can get very clever and make the drop downs data dependent

 

But, keeping it simple

In my example I have P2 SKUs with a Parent P1 Products

2019-06-27_11-51-07.png

 

Create two line items - one formatted as the parent list, and the other as the child

2019-06-27_11-52-17.png

 Now when creating the child list you will see some other options at the bottom

Click dependent and the default below should appear

2019-06-27_11-52-35.png

that's it!!

2019-06-27_11-53-17.png

 

2019-06-27_11-53-30.png

 

 I hope this solves it

David

 

Message 4 of 8
Highlighted
Community Boss

Re: Sorting of list when used as line item

Hi, 

 

Another way to change the order of the elements with "parent first" is to activate the security on the list that you need to change the order, give access to all the users at "total" of the list and, very important: in the formatted line-item flag "Selective Access" (see attached picture).

 

For some strange reason, activating on the line-item the "Selective access" or creating dependent lists as @DavidSmith suggested the order of the elements changes with "parent first".

 

However, is quite frustrating that is not possible to control this behavior. 

 

Cheers

Alex

Message 5 of 8
Community Boss

Re: Sorting of list when used as line item

Message 6 of 8
Contributor

Re: Sorting of list when used as line item

 Alex,

I almost cannot believe it myself but your suggestion worked perfect - many thanks!

One question though - if I add a new user, will I have to manually give them access to the list in question?

Thanks!

/Fredrick

Message 7 of 8
Community Boss

Re: Sorting of list when used as line item

Yes..indeed. you need to setup security for the new users.

Ciao
Alex.
Message 8 of 8