help for pivot add extra Calucated item

[santosh226001]

Hello Sir i m working for my a share transaction pivot.. which is enclosed

We make a pivot talbe for reports generate.
there are two type daily transation 1 is Delivery Base & 2nd is Intraday
In Delivery Base any client take positon for few days then after he sold buy shares

We want to also that show report Balance Stock Qty, Amount & Net Avg Rate in pivot

Eg in Pivot

Delivery
Buy Sold
Qty net Amount Qty net Amount
15 1500 10 1000


We want pivot following
Delivery Net Balance
Buy Sold
Qty net Amount Qty net Amount Qty net Amount Avg Rate
15 1500 10 1000 5 500 100


my Sheet is enclosed pls help if that is possible with VBA, Function or Formula

Thanks in Advance

Santosh