I have a main table listing the following:
SalespersonID, SalesDate, ProductID
11, 01/01/13, aaa
11, 01/01/13, bbb
22, 01/02/13, aaa
22, 02/02/13, bbb
22, 03/02/13, ddd
33, 04/04/13, aaa
44, 05/05/13, eee
55, 04/04/13, aaa
55, 04/04/13, bbb

I did a pivot table with the rows being SalespersonID and SalesDate and the column heading as ProductID and the value as ProductID (count).
I need to eventually see only Product Id of both aaa and bbb for a Salesperson on the same date. I can see the results in a basic pivot table if you scroll down looking for the results but I want to see the results without scrolling down looking for them. I know you have to put a formula in the source data, i don't know where to start. In this example I would want to see SalespersonID 11 and 55 who both have aaa and bbb on the same date.