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?
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.
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.
Hi @Takamasa ,
Tree view is not available for Columns.
However you can try using conditional formatting to differentiate Parent from Child.
Hope this helps.
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.
We're looking to feed live or near-live Anaplan data into Claude through MCP, but our current approach — exporting CSV files via the Anaplan Bulk Export API, loading them into MySQL, and querying from there — has a significant lag (hour-long turnaround). Curious if anyone has found a faster path, whether that's through the…
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
