hi!When I check list items in the parent hierarchy, I want to create a mechanism to check all items in the child hierarchy.
What i should do?
Please help me.
Hi @KubotaNatsuki ,
In your query, assuming 'Check' = assigning ✅ to a list item in parent list, you can Lookup the parent property (which @ChrisAHeathcote explained) to apply it to child items pertaining to that parent.
Regards,
vinayvm
Hi @KubotaNatsuki
You'll need to provide more information.
I find that a working sample on Excel that you attach here normally helps.
Thanks,
LipChean
@KubotaNatsuki
Create a module dimensioned by the child list.
Add a list formatted line item containing the parent list.
Use; ITEM(PARENT('Child List')) to pull through the parent of the list item.
Now you can see the parent of each child list item in a single location. If a child list item does not have a parent then the result will be blank.
@ChrisAHeathcote
Shouldn't it be PARENT(ITEM(Child List))?
Misbah
ha!
Yes you are right.
Thank you for your reply!
I got it to use Lookup!! Thank you!!
Thanks for your reply!
I can do it to use 'Lookup' and 'Parent' function!Thank you so much!
While using LOOKUP will return the parent list item as per a mapping module dimensioned by the child item but the formula will not be as efficient as using PARENT.
This one is not for the faint hearted lol. Functionality is to have ability to capture business policies at different levels of the hierarchy. Business policies have customer and product as dimensions. The customer/product list levels is configurable. Customer list has the following hierarchy: Country ⇒ Channel ⇒ Customer…
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
