How to consolidate 3 lists part of same hierarchy

Hi,

I'm building an FP&A and is right now working on the FTE part. I have three lists:

1. E4 Employees # - this is the main Headcount file from HR

2. E4 Recruitments # - this is the monthly recruitment file with people that are signed to start in the future

3. E4 New Asks # - this is a list populated by users going into Anaplan UX and adding new asks manually

These three lists are all on the same level (4) in a hierarchy from top to bottom: Function (1) -> Region (2) -> Cost Centre (3).

The client is now wondering if we can consolidate these three lists on a static monthly basis into one list for reporting analysis purposes. So when the latest forecast becomes the budget they want to merge these lists and use a new one, ex. E4 Budget Employees #, to drill down on.

1. How can I build this new E4 Budget Employees # list containing all three top ones?

2. Is this the smart way to go for this kind of process in Anaplan? The client is new to Anaplan and not sure if what makes sense in Excel is right way forward here.

Please bare in mind question 1 is the important one to be resolved in any case.

Best regards,

Johan

Accepted answers

rob_marshall

@johan.marketoft

Why are those in three different lists and not one, and then create 3 different subsets (one for Employee's, one for Recruitments, and one for New Asks)?

Rob

All comments

rob_marshall

@johan.marketoft

Why are those in three different lists and not one, and then create 3 different subsets (one for Employee's, one for Recruitments, and one for New Asks)?

Rob

johan.marketoft

That's a good point Rob. I think if I would do it from the start that's how I'd go about it. But since we are now in the end of the project and doing some additional stuff for the client I'm a bit wary of going back and change all that. I seem to get the hang of how to do build the list based on previous ones from saved views so think I'm OK with my question at the start actually. But I will talk about your idea with the Solution Architect in the team to see if that is something we should go ahead with, thanks!

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