How to calculate Split/Volume at Customer Level

[former_member618787]

Dears,

We need to calculate the Split at Product / Location / Customer Level. We created a planning job using aggregation level Apo Customer, Apo Location, Apo Product, Segement (customer group 4), Sales Territory (sales group), and Sales Zone, and built a macro to calculate it.

When we check result in the planning book, at customer level it shows the same amount for each product / location /customer level, no matter the customer we check. Disaggregation at Product / Locations level is OK. The concern is when we go to Customer level.

The ratio which calculates the Split, uses Calculation Type = P (based on a different key figure) and Time-Based Disaggregation = K (based on another keyfigure). For both, it is based on APODPDANT.

Can anybody help to understand what is wrong and/or guide on what to do.

[riyazahmed_ca2 · Accepted solution]

Hi Freddy,

APODPDANT might not have any values due to which your concerned KF results in the equal split. This is the standard keyfigure which is calculated based on history and widely used for disaggregation and aggregation purpose.

Regards,

Riyaz