Hello,
I am working on a database about consumer behavior.
I have a problem to get cross-consumption figures.
To be more concrete:
I have a list of consumers who buy different products (apple and banana) which have different prices.
I would like to know the share of revenue from the consumers who buy only apples, the share of revenue from the consumers who buy only bananas and the share of those who buy both apples and bananas.
My problem is that I am able to know the share of revenue from those who buy banana and from those who buy apple BUT I do not know if these consumers have also bought the other product.
I have tried to create some groups but I have not been successful in showing the duplicates (duplicates from group of apple buyers and group of banana buyers are actually the consumers who buy both apples and bananas).
May you help me?
Thank you in advance!
See the attached, which works using 8.1 and data sources that support the IN/OUT of sets. I used two conditional Sets to identify Names who had bought Apples or Bananas, then a Combined Set to identify the shared members (people who had bought both). A calculated field then returned a single dimension:
The path that Kettan was on could also lead to a solution, however the table calcs can get pretty messy.
Jonathan
