Person Product
-------- ----------
Sales1 ProductA
Sales1 ProductB
Sales2 ProductA
Sales2 ProductB
Sales3 ProductA
So I would like to see that "Sales3" did not sell "ProductB" and in SQL I can do that with this query
Code: Select all
Select t1.person from table t1 where t1.person not in ( Select distinct t2.person from table t2 where product='ProductB")
And then display in a table on the dashboard.