Highlighted
Occasional Contributor

Drill down function showing lists in incorrect format

Hi all,

 

Wanted to ask for a best solution of this question if possible.

 

I have a set of data which is populated by a subset. When I drill down into the data, the order of the lists are not in the order they should be. I have checked the list which shows the correct order. Is it possible to change the mappings/settings of the drill down options to show the lists in the correct order?

Screenshots attached below showing the correct order vs the incorrect order in the drill down function

 

 

17 REPLIES 17
Highlighted
Master Anaplanner/Community Boss

@Re: Drill down function showing lists in incorrect format

Hi @jatinnayi,

 

Is the list you are using a numbered list? 

 

If it is then then the creation ID will display the order of how it shows in the drill down. 

 

Otherwise I would expect it to show in the correct order as in your hierarchy structure. 

 

Please can you explain which type it is.

 

Thanks,

 

Usman

Highlighted
Occasional Contributor

Re: @Re: Drill down function showing lists in incorrect format

Hi @usman.zia 

 

Thanks for your response. We are using a 'Composite Hierarchy List'. I'm not sure when I drill down why the list is changing order.

 

Thanks, Jatin.

Highlighted
Master Anaplanner/Community Boss

Re: @Re: Drill down function showing lists in incorrect format

@jatinnayi

@usman.zia hunch is the same as mine. You can tell if it's a numbered list by checking your General Lists tab. If the list is checked in the Numbered column, it's a numbered list. 

 

NumberedList.png

 


Jared Dolich
Highlighted
Master Anaplanner/Community Boss

Re: @Re: Drill down function showing lists in incorrect format

@jatinnayi 

Also could you show the formula for the cell that you are drilling down on? 

 

Thanks,

 

Usman

Master Anaplanner/Community Boss

Re: @Re: Drill down function showing lists in incorrect format

@jatinnayi ,

 

I believe @usman.zia is correct in that the sort or display is based off the internal address of the member which correlates to the order it was created, whether it is a numbered list or a "regular" list.

 

Rob

Highlighted
Master Anaplanner/Community Boss

Re: @Re: Drill down function showing lists in incorrect format

@rob_marshall , @usman.zia ,

This would be good for me to learn too.

Are you saying then to get the order corrected, the lists must be reloaded in the order you want them sorted?

 


Jared Dolich
Highlighted
Master Anaplanner/Community Boss

Re: @Re: Drill down function showing lists in incorrect format

@Jared Dolich @rob_marshall 

 

List item order management is something that can be difficult to manage in models that are always growing. 

 

Has there been a best practices guide published on this? 

 

Thanks,

 

Usman

Highlighted
Master Anaplanner/Community Boss

Re: @Re: Drill down function showing lists in incorrect format

@Jared Dolich @usman.zia ,

 

You have to be very careful, currently, when wiping a list and then recreating it because all of the data associated with that list will be wiped as well, so that is not feasible.  I need to see if this in idea exchange and if it is not, I will add it because I think think this is a big miss.

 

Rob

Highlighted
Master Anaplanner/Community Boss

Re: @Re: Drill down function showing lists in incorrect format

Thanks @rob_marshall  please be sure to share the link to idea and you'll have my support!