Distribution process

Hi All,

I have the following structure in my BPS cube

Country, Material, Sub seg grp, Customer, Var Mgn.

#,#,137,#, 1000

BA, 4566, 137, 8003, 135

CA, 3456, 137, 8004, 126

US, 1234, 137, 8002, 100

#,#,135,#, 2000

BA, 3456, 135, 8008, 65

CA, 7658, 135, 8005, 77

US, 9846, 135, 8009, 50

I would like to distribute the first records variable margin 1000 into the remainining 3 records. And i need to maintain the current var mgn ratio.

I tried the Distribution by Key, Ref Data, Ref key. Nothing helps to me.

Am I missing here, Please give me some tips.

Note: BW 3.5 BPS.

Thanks

Billy