I am currently working with a document that contains a customer ID and all of the accounts that each customer has. These accounts can belong to either company 1 or company 2. The way that I am displaying this data is via a pivot table with the customer ID as the main dimension, the account number as the second dimension, and the company name as the third dimension. So for one customer ID I can have multiple account numbers, each with a specific company name.
What I would like to do is identify those customer IDs that contain accounts in both company 1 and in company 2 and only display those. Is there any way that I can do this?