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.
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
