Create list which is a combination of multiple lists

Hi,

I am trying to create Revenue Module which should include accounts, Cost centre, Projects & products (4 different lists). But i am getting exceeds size limit error when i try to include all 4 lists in one Module. Can someone give any suggestions to build this module? Is there a way to create one seperate list which includes all 4 lists as a combination. So that i can use that list to create module..?

Thanks,

Sangeetha

Accepted answers

All comments

DavidSmith

I would question the value of all four lists in one module anyway; from experience it is likely that you want to sum the values into a module by Cost Centres and Accounts

The to make a decision it is important to understand the relationship between the 4 lists.

Are all accounts applicable for all Cost centres?

Are Projects "children" of cost centres?

Do projects only contain certain products?

I obviously don't know the answers to these questions; leaving aside the first question, and assume that the answer to the second and third questions are yes I would recommend the following:

Create a numbered list called projects and include Cost Centres as the parent, and then also create a numbered list called Project>Products and include Projects as it's parent. That will "flatten" three of the lists into one hierarchy. The numbered list functionality will allow the same project "name" to be used for mulitple Cost Centres, and it will also allow the Assign functionality to be used if the users are to create projects and assign products to those project.

Again, I'm making assumptions, but assuming that a project is linked to an account, it is better to store that attribute as a field and then use a SUM function to pull the project details into the module by Cost Centre and Account

Obviously there are a lot of assumptions above, but the answer does depend on a lot more information. If you post the rationale and what you are trying to achieve from the process I can probably give you a more targeted answer

Hope that is helpful

David

Sheetal_Dixit

Hi David,

I'm currently facing a similar problem.

I have 4 lists : category, brand, format and pack size.

All o f these are dependent, in the sense category is the parent of brand, brand is the parent of format and so on.

Pack size is the last of the hierarchy so in this list all the above are present.

I want to display these in the module in such a way that category, brand, format and packsize all 4 dimensions should be present and it should display only valid combinations.

To make it clearer, if there are 100 packsizes but only 50 are applicable to one brand and 60 to another, if i select the particular brand only those 50 or 60 combinations should be displayed, but we can't use just the one pack size list, because I want to display the other dimensions too which is in sync with the valid packsizes.

Could you please provide insight on how this can be achieved?

Thanks,

Sheetal Dixit

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385