How to calculate the total cost for item group?

[priyalvp24]

Hi All,

As per my requirement,want to calculate the group total.

Scenario is as below.

If my Item No. =''SF00001'' then cost per item = Row Total/Quantity.

e.g. for Document Number 57,cost per item = 12250.3/332350 i.e.0.03685.

now my next requirement is

if (Item No. =''FG00002''  then 0.03685*100*Quantity)

if (Item No. =''FG00005''  then 0.03685*50*Quantity)

if (Item No. =''FG00006''  then 0.03685*25*Quantity)

again drill down should be possible upto Document Number .

SF00001 serise is for semi-finished goods.

FG serise is for finished goods..

Please help.

Regards,

Priyal