Solved

# Creating Hierarchies with dimensions & Break-back

• 165 views

• Just Arrived
• 0 replies

Hi,

Can anyone suggest how can we create hierarchies using dimensions list and use it & how we can input values at a total level and get it break-back down at item level?

Thanks

icon

Best answer by BrunoRodriguez 9 November 2023, 09:01

View original

Userlevel 3
+5

Hello @Saurabh Kapoor ,

If I understand correctly your question, you have a unit - let’s say volumes - and you have a hierarchy - let’s say a 3 level hierarchy.

My suggestion is the following:

1. Metric 1: Identify the volumes at level 3
2. Metric 2: Aggregate them into level 2
3. Metric 3: Metric 1 / Metric 2
• This will result in the % that each level 3 represents of its level 2 parent.
4. Metric 4: Add an input at level 2
5. Metric 5: Metric 4 * Metric 2
• This will result in the number being disaggregated accordingly into every level 3.

For level 1, you would only have to apply the same logic. I hope it makes sense!

Kind regards,

Bruno