Sum by Parent

New Contributor

Sum by Parent

In a module I have sales by product by country  (List: Org L4 Region) displayed monthly, but in the same module we want to sum at a higher level by region as well, North America, Latin America, ect.(List: Org L1 Region). Mainly what we’re looking to identify is if a product was sold in a region, but still have the country level data in the same module. Is there a way to sum by parent ( the region the country is located in) or another solution to acheive this?

Message 1 of 2
1 REPLY 1
Super Contributor

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.

 

Thanks,

LipChean

Message 2 of 2