2 Replies Latest reply: Feb 9, 2018 3:48 PM by Voltaire Villajoaquin RSS

    Need help with grouping data while excluding others

    Voltaire Villajoaquin

      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