Need help with grouping data while excluding others

[Anonymous]

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                                                                        

[siddharth_s3]

Please give a snapshot of how the data model looks like?

[Anonymous]

Thank you but I think I found a workaround.