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