Solved

Creating Hierarchies with dimensions & Break-back

  • 8 November 2023
  • 1 reply
  • 165 views

Badge

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

1 reply

Userlevel 3
Badge +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

Reply