Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need help in summarizing information based on a product's sales result. Example is below, I need to see how many Nintendo customers buy Xbox products and how many Non-Nintendo customers buy Xbox products, the grouping is based on Nintendo customers. Both Nintendo and Xbox are in the Product field. Thanks.
Products
Customers Nintendo Xbox
Cust 1 $5 $10
Cust 2 $0 $15
Cust 3 $0 $15
Cust 4 $15 $0
Nintendo customers $15 $10
Non-Nintendo $0 $30
Please give a snapshot of how the data model looks like?
Thank you but I think I found a workaround.