SAP IBP past 15 months sales average (not rolling) in current and future buckets

[former_member617235]

Hi All,

Need your help, we have at an aggregated level i.e. "Promotion" and then it will disaggregated at a base planning level proportional on the average of another key figure, specifically on the sales of the past 15 months only i.e. "Actuals Qty"

In the example below, 1 product has 2 customer and each customer has 2 location.

The "Actuals Qty" for the past 6 months with its corresponding average at the PROD-CUST-LOC level

Then in another key figure "Promotion" the planners input value at a PROD-CUST level for the current month onwards.

It has to disaggregate at a PROD-CUST-LOC level based on the "Actuals Qty" sales average for the past 15 months. Means for PROD1, CUST1 and LOCA1 it should be multiplied by 54.55% for current and future periods.

Thanks,

VM

[AyanBishnu]

screenshot missing