Can I select a Parent within the same list and also another list?

kdoan

I want to be able to select the parent from the same list and also another list, is there a way to do this?

I am creating a Chart of Account, so there are certain account in the same list that I want to group it under.

Example.

1000 -- General Stuff

1001 -- General admin stuff

1002 -- General Sales stuff

In this situation, I want 1001, and 1002 to have 1000 as the parent list.

However, I want 1000 to have General Liability as the parent from another list.

I know I can just throw it all in the same list and call it a day, but I want to be able to breakdown the hierarchy.

Example.

COA L1 -- General Liability, General, Asset, etc

COA L2 -- 1001, 1002, 1003, etc

My chart of account is far more complicated than this but I want to know if there a way to have parent from other list and the same list. I included a screenshot to show my chart of account.

Screen_Shot_2019-07-11_at_12_48520.png

Accepted answers

All comments

DavidSmith

I'm not sure I understand fully what you are asking but

A list can be multiple parents of different child lists

e.g. a Country list can be the parent of City and the parent of a separate list called Territories

However, you cannot then have both of those lists in a module (if you were thinking about that)

I hope that helps clarify the situation, If not, please could you shed more light on specifically what you are trying to achieve

David

kdoan

@DavidSmith

Sorry for the confusing wording. Basically, I have 2 list. Lets call it territory. Inside the list 1 I have Asia, Africa, America, etc.,

In list 2 - I have CA, NY, Japan, China, San Francisco, NYC, Tokyo, Hokaido, Shanghai, etc.

In these two list, I want to structure it like this.

List 1 -- Asia, America, Africa, Europe

List 2

Japan --- (Parent: Asia)

Tokyo -- (Parent: Japan)

Hokaido -- (Parent:Japan)

CA -- (Parent: America)

San Francisco -- (Parent: CA)

Los Angeles -- (Parent: CA)

I hope this help.

DavidSmith

What you are describing looks like what we call a "Composite" or "Balanced" hierarchy

G1 Region

G2 Country

G3 City

So you could definitely set up the list that way.

However, you mention the second list which would be made up of G2 and G3

You can maintain that list as a flat list and associate each member with the relevant G2 or G3 member by having a line item formatted as G2 and G3 respectively. If you use the same code for the member of G2, G3 and the flat L2 list the association is easy and can be managed with a FINDITEM formula

Alternatively, you can create a module dimensioned by G2 and have a line item formatted as the flat L2 list. And do the same for G3, again using FINDITEM to map the list members together

That way you can then use SUM or LOOKUP to transform and /or aggregate data between the structures

How you structure the lists will depend on the logic and calculations you need, but the thing to bear in mind, is that Anaplan does not need to have hierarchies for everything and doesn't need hierarchies to aggregate data - we can use SUM on formatted line items to achieve the same result

I hope that helps clarify things

David

Quick Links

Can you help?

Unanswered questions

Unable to use one page for multiple DEV models that are partially in sync
Hello, Our model builders are normally making changes to all structural changes in a DEV model. Because we are now in a Prod freeze and we don't want to move structural changes to PROD until end of year, we created a copy of the DEV model (standard mode) - 'DEV2' model, where we are only making changes to urgent issues…
Anaplan for Microsoft 365
Using the excel addin for Microsoft 365 when I try to add a card to import data I get the message 'Cannot insert data from a custom view'. I am not using a custom view. Any ideas what I am missing here?
Data Split between Many to Many Relationship Mappings
Hello Anaplan Community, I am encountering an issue with one of my development work and would be greatly appreciated your assistance. There are 2 different modules involved in my model: 1) INP01 Percentage Input by Product (Applies To: P3 List) 2) REP01 Percentage Split by Department (Applies To: Departments List) The…