Skip to Content
0
Former Member
Oct 25, 2007 at 09:25 PM

Planning Book Macro with respect to Characteristic

9 Views

Hi All,

I think its a simple macro since I am new unable to figure it out. I have a characteristic for customer types. Ex: C1 & C2.

Requirement: KF1 + KF2 = TOTKF

TOTKF 125(agg.)

C1 25

C2 125

KF1 100(agg.)

C1 50

C2 50

KF2 50

C1 25

C2 25

I want KF1 aggregated value to be only added to C2 of TOTKF (Total KeyFigure) and the remaining qty from KF2 should be added to TOTKF and disaggregated accordingly.

Can somebody who is familiar with macros help me out.

Thanks,

Harish