hierarchy list and child list

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.

Accepted answers

Vinay VaradarajM

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

All comments

LipChean_Soh

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

ChrisAHeathcote

@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.

Vinay VaradarajM

Hi @KubotaNatsuki ,

Regards,

vinayvm

Misbah

@ChrisAHeathcote

Shouldn't it be PARENT(ITEM(Child List))?

Misbah

ChrisAHeathcote

ha!

Yes you are right.

KubotaNatsuki

Thank you for your reply!

I got it to use Lookup!!
Thank you!!

KubotaNatsuki

Thanks for your reply!

I can do it to use 'Lookup' and 'Parent' function!
Thank you so much!

ChrisAHeathcote

@KubotaNatsuki

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.

Quick Links

Can you help?

Unanswered questions

How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
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.…