Sum specific product sales from one e-mailadress
I've a data file which contains customer purchases.
Product 1 - Email1
Product 2 - Email2
Product 3 - Email3
Product 1 - Email4
Product 2 - Email1
Product 3 - Email1
If the specific e-mailadress purchased both product 1 and product 2 (the bold lines above) the answer should be 1. It doesn't matter if he also purchased product 3.
Hopefully my question is clear, is this possible with beastmode?
Thanks in advance.