Difficulties filtering datas on charts

[#1]

Hello,

I have let say such datas :

product1 vendor1 10€

product1 vendor2 11€

product2 vendor1 9€

product2 vendor3 13€

product2 vendor4 12€

And in another table : vendor1 company1 / vendor2 - company1 / vendor3 - company2 / vendor4 - company3

I want to get the list of product wich have only vendors from company1 and company2 ??? (please see attach)

I can't do that if you can help that would be great.

Thanks.

[#2]

I've attached a sample. It got pretty messy, but it does the job. First, it counts the number of times company3 or company4 appear for any given product. Then I used an if...then to only sum where that total equaled zero.

This could be simplified a bit by creating a variable to store the Count expression.

vCount = Count({<Company = {'company3', 'company4'}>} total <Product> Product)

Then you could simplify the whole expression to be:

If($(#vCount) = 0, Sum (Amount), Null())