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
Bookmarks