I'm new to pivot tables - I've just been watching some tutorials on youtube - but there's something I want to do, but haven't figured out how to do it yet.

Let's say I have data like this:

TransactionDate, CustomerName, PartNo, PartSubTotal
01/01/16, CompanyA, Part1, $50
05/02/16, CompanyB, Part2, $20
15/03/16, CompanyC, Part1, $5
20/03/16, CompanyA, Part3, $10
22/03/16, CompanyA, Part2, $20
25/03/16, CompanyB, Part1, $5
29/03/16, CompanyA, Part3, $10

Now I can get a pivot table that shows the sales per customer separated by indivual parts (CustomerName and PartNo in rows, PartSubTotal in values)...

...but how do I get it to display a table that shows the same thing, but ONLY for customers that purchased a "Part2"? (and I mean it still displays ALL the sales for companies that have purchased a part2, not just the part2 sales)


(basically I'm running a promotion, and I need to identify which customers have purchased a specific product at some point in the past - only those companies will be eligible for the promotion. BUT, I want to view the sales records of those (and only those) eligible companies to see what else they're buying, as if they're buying certain other products I may not want to send them the promotion)