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

[former_member703940]

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

[piyush_parekh · Accepted solution]

Hi,

Aggregate key figures KF1,KF2 and KF3 by adding below calculation in respective key figures:

KF1 at MTHLOCPRODCURR = SUM(KF1 at MTHLOCCUSTPRODCURR) and so on.

For Sum KF4, write below calculation definition -

Sum KF4 at MTHLOCPRODCURR = KF1 at MTHLOCPRODCURR + KF2 at MTHLOCPRODCURR + KF3 at MTHLOCPRODCURR

Hope this helps!

Regards,

Piyush