how can i sum pivot table filtering some values another table

[moogii1102]

i need to sum pivot table's filtering some values in other table but if i change filter criteria, value is also changed.

For example:product apple, banana
company A B
price A company apple=1 banana=1
price A company apple=2 banana=2

i will buy apple for A company 3 and b company 2, total amount is 7.

So pivot table filter company and row labels product

what formula use to see total amount 7 in pivot table

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.