nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to create tree style

Takamasa

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?

Accepted answers

Niranth

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)

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

VSekar

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.

All comments

Niranth

Hi @Takamasa ,

Tree view is not available for Columns.

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

Hope this helps.

Takamasa

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)

Niranth

Hi @Takamasa

By Conditional Formatting I mean,

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

Takamasa

I understand.
Thanks a million!!
I'll try at once.

VSekar

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.

Takamasa

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

VSekar

Takamasa

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

Quick Links

Can you help?

Unanswered questions

An Update on Anaplan Audit Log Reporting: A No-Code Approach
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Top-Down Allocations
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…