Skip to Content
Nov 05, 2020 at 03:15 PM

How to summarize with a helper key figure for different key figures and planning levels

177 Views Last edit Nov 05, 2020 at 03:20 PM 4 rev

Dear experts,

I am facing a key figure calculation problem. As you can see below I have 3 different calculated key figures (KF1, KF2 and KF3) on planning level Month | Location | Customer | Product | Currency with the prices.

I need to calculate with a helper key figure "SUM KF4" summary prices of each product indenpent of location and customer.

It means, The helper key figure SUM KF4 has summarized prices for all locations and customers for each product 1 and product 2.

How can I create a helper key figure with this calculation in ibp?

Thanks and Regards