Creating Hierarchies with dimensions & Break-back

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