distribute cogs

[fosben]

I have a value in cogs_total_dist I want to distribute.
lets say cogs_total_dist = 1 000 000. this is a calculated value from several tables based on a percentage.
I want this value to be distributed based on the sum value (cogs) in the table cogs_shop by division when I view it in a matrix. 
The table cogs shop have the columns date, division, cogs

Whatevery I have tried, I get the correct value in the total of the matrix, but not on the divisions in the matrix, they are left with small numbers or blank. 

any suggestions ?

[some_bih]

Hi @fosben 

please share example / file of data as input for expected output.