Drill down function showing lists in incorrect format

Options
jatinnayi
jatinnayi Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor
in Security

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

 

 

Tagged:

Comments

  • jatinnayi
    jatinnayi Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor

    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.

  • jatinnayi
    jatinnayi Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor

    Hi all,

     

    Thanks for your responses and investigations.

     

    After conducting some testing of my own I found that @JaredDolich  point about reloading data in the order you want them to be sorted is correct.

     

    We began to reorder data in the format that we wished for it to be populated in (e.g. directorate levels in numerical as the screenshot attached shows) and then switched to entering data for the last directorate (7) and then moved back to doing it for directorate 4. This then began to throw out the order of the drill down views as you can see in the screenshot.

    anaplan 3.PNG

     

    We realised that selecting the data in the order we want them to be sorted in will bring back the correct results but after a forecast/actual is added – it will then throw out the order of the list.

    Looking forward to see what the next steps might be.

    Thanks, Jatin.

     
  • jatinnayi
    jatinnayi Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor

    Hey Callum,

     

    Thanks for your response! It was very useful to learn that this workaround can be processed in a single step. I agree with the idea of the enhancement, I look forward to putting this in use.

     

    Thanks a lot! Jatin.

Categories