Sorting of list when used as line item

fredrickstraube

Hi,

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

In 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

alexpavel

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

DavidSmith

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

fredrickstraube

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

DavidSmith

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_Picklists.htm?_ga=2.9772924.87331419.1561632600-275155482.1561632600

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

 

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

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

Click dependent and the default below should appear

that's it!!

 

 

 I hope this solves it

David

 

DavidSmith

@alexpavel @fredrickstraube 

Idea exchange created

https://community.anaplan.com/t5/Idea-Exchange/Totals-position-for-formatted-list-items/idi-p/47926#M3179

 

David

fredrickstraube

 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

alexpavel

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

Ciao
Alex.