Sum by Parent

New Contributor

Sum by Parent



Master Anaplanner/Community Boss

Re: Sum by Parent

Hi BenBerube,


Assuming you have 4 lists, i.e. L1 Region, L2 Sub Region, L3 Sub sub Region, L4 Country, and they are all connected via 'Parent Hierarchy', such that:

Parent hierarchy of L4 is L3;

Parent hierarchy of L3 is L2;

Parent hierarchy of L2 is L1.


Then in your module that has Product, L4 Country and Month, you need not do anything more, because Anaplan automatically aggregate the values from multiple L4 to the same L3 parent; and from multiple L3 to the same L2 parent, and multiple L2 to the same L1 parent.




Super Contributor

Re: Sum by Parent

Hi @LipChean_Soh.


Please tell me, how can I export parent level hierarchy data.

I really need it.


I have posted in forum.

Please let me know, if you want me to tag in that question.