multiple data sheet piovt table

[kalpesh]

Hello


sheet1 name sale
sheet2 name purchas

sheet sales data belo

Date Billno Party Paritcular Qty Rate Amoun
1-2-12 12021 vipul r mango 25 100 250
3-2-12 24560 mahesh vanila 20 50 100
10-2-12 65696 hitesh sitafal 40 40 160


sheet2 purchase data belo

Date Billno Party Paritcular Qty Rate Amoun
26-1-12 121 ganesh mango 50 60 300
28-1-12 24560 ganesh vanila 40 100 400
10-2-12 65696 ganesh sitafal 60 50 300


now i create piovt table with multipulse sheet data so maintain stock
amou


how