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

[rajeshturaha]

Plz see the attachment, if that helps

[santosh226001]

Sir Thanks for shownig intrest

Actually sir we want difference in where u show Total Qty

in Delivery Bought Qty 20
& in Delivery Sold Qty 10

We want 20-10 = 10 Difference Qty and same as difference of net amount

after that if possible then we want to AVG rate of Diffenrece Qty & Net Amount

Thanks

[rajeshturaha]

I Think that have to be done manually. As far my knowledge that can't be achived in pivot table. Extra calculated item can be achived with different colomns, but what u want (diff between sold & brought qty ) exist in the same coloum in your sheet. Plz see sheet5, where table created manually with formulas. Hope that might solve your purpose.

There might be other answers.
Plz update

[santosh226001]

Thanks sir,, we want same result.. but i think this sheet5 must bhi update manually every time when we enter new details???

any way thanks for help.. we got logic that's most important to solve my problem

[rajeshturaha]

While going through your sheet, i found something new that might help you, and wanted to share with you.
I have created new fields from calculated items (Qty Diff & Amt Diff). Now from value fields of PV click on sum of qty diff, select "value field setting - show value as" , and select "difference from" and under base field select "Type b/s".
I have attached screen shots in the sheet, for u to better understand.
Hope this will help.