We can get the data from lower level to higher level by applying SUM or LOOKUP.
But if we already have data at higher level and want to get at the lower hierarchical level, how should we do it?
@Soumyajaiswal
First, SUM is not required if you are aggregating the data from lower level of hierarchy to the Highest Level. It will auto aggregate.
Second: In order to do the Top down approach we generally use LOOKUP. But you need to set a logic right as in how are you going to dis aggregate the data . For example If you have one Region and under that region you have got 3 areas
A1
A2
A3
R1
Let's say Region has got 100 as a value in it. Now you need to figure out how are you going to dis-aggregate this 100 into 3 areas. You can use Prior year actual's ratio or you can set up your own distribution ratio. In your area module you use LOOKUP functionality and multiply that with your ratio.
Or else if you simply want to pull down 100 in each Area use Simple LOOKUP on your Region and it will pull the value 100 in each area
Hope that helps.
Misbah
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
