How to create tree style

Highlighted
Occasional Contributor

How to create tree style

Hi!

I want to show tree style like under one on the columns about List.

I tried but tree view disappeared like above when I changed from raw to columns.

Is it possible to show tree on the columns?

tree.PNGtree2.PNG

Message 1 of 9
8 REPLIES 8
Certified Master Anaplanner

Re: How to create tree style

Hi @Takamasa ,

 

Tree view is not available for Columns.

However you can try using conditional formatting to differentiate Parent from Child.

 

Hope this helps.  

Message 2 of 9
Occasional Contributor

Re: How to create tree style

Thank you for your reply.
How can I differentiate Parent and Child of List??
On the conditional formatting, I can just only customize about Line item. (Not List item)
Message 3 of 9
Certified Master Anaplanner

Re: How to create tree style

Hi @Takamasa 

 

By Conditional Formatting I mean,

You can create a separate line item which has a lesser value for Child (say 1) and a greater value for parent (say 5) and then apply conditional formatting based on the new line item which you created. You get a result where Children will have a lighter colour and parents a darker colour.(Refer my screen shot)

clipboard_image_0.png

 You can even try using 3- colour scale in conditional formatting and achieve different colours for parent and child.

Tags (1)
Message 4 of 9
Occasional Contributor

Re: How to create tree style

I understand.
Thanks a million!!
I'll try at once.
Message 5 of 9
Contributor

Re: How to create tree style

Hi @Takamasa,

 

It is not possible to see the list as tree view in column. But one thing I can think off to differentiate between parent and child is by having some prefix in the list itself. But by doing do, will have impact on the mapping of existing metadata load. 

 

If you have no formula on the members in the module(as per your screenshot), then you can easily differentiate by blue(child) and black(parent) color. 

 

 

Message 6 of 9
Occasional Contributor

Re: How to create tree style

Thank you for your reply.
Sorry, what is mean "having some prefix in the list itself".?
Message 7 of 9
Contributor

Re: How to create tree style

I mean adding some key words before the member name in the list. For example, in your screenshot you can rename the north east as AR-Northeast and so AR-New York, AR-Mid-Atlantic, ZN-US East. Where AR means a short form of area and ZN means a short form of Zone. 

 

This is one of the simple work around which works globally across your model. In this way, you can differentiate the parent and child across all the modules just by changing once in the list. But your customer/users should be comfortable on the naming conventions. 

Message 8 of 9
Occasional Contributor

Re: How to create tree style

I understand.
Certainly, prefix can make columns differentiate.
Thank you so much.
Message 9 of 9