theThirdMan
New Member
- Joined
- Dec 3, 2012
- Messages
- 6
I have a sheet with 3 Columns of interest:
Employee, Product, Customer type (3 possible- A,B,C)
I have a pivot table that breaks up the data as employee and product in rows, and the customer type in column so that it is 5 columns (Employee | Product | A | B | C). I need only the rows in which the employee sold the same product to both A and B, A and C, or B and C. I know it is impossible to filter by such criteria in the pivot table itself, but is it possible to create a flag column in the raw data which I can use to filter? I've been trying to configure and array function along with a if, but am having no luck. I'm not sure if my knowledge of arrays is just poor or if its not the right method.
Does anyone have any advice/suggestions?
Employee, Product, Customer type (3 possible- A,B,C)
I have a pivot table that breaks up the data as employee and product in rows, and the customer type in column so that it is 5 columns (Employee | Product | A | B | C). I need only the rows in which the employee sold the same product to both A and B, A and C, or B and C. I know it is impossible to filter by such criteria in the pivot table itself, but is it possible to create a flag column in the raw data which I can use to filter? I've been trying to configure and array function along with a if, but am having no luck. I'm not sure if my knowledge of arrays is just poor or if its not the right method.
Does anyone have any advice/suggestions?