Ditribution by Weight

Hi Techies,

My client wants to distribute planned volume across periods depending on their historical share which must be calculated by BPS

Product Account TotalVolume HistoricalShare JANVOL FEBVOL MARVOL ...> 12 PERIODS

(How to get this column value)

01 001 1000 ? (1000/TOTAL(tOTALVOLUME)*100) 100 150 200 ..

01 002 2000 ? (2000/TOTAL(tOTALVOLUME)*100) 200 250 200 ..

01 003 1500 ? (1500/TOTAL(tOTALVOLUME)*100) 100 150 200 ..

-

TOTAL

is it possible to do that, if so please suggest me the solution