2 Replies Latest reply: Aug 8, 2012 10:37 AM by THe_evaco RSS

    Product CrossTable

      Hello all,

       

      any idea how to solve this:

       

      I have a simple table with 3 columns: Customer, Product, Units.

      It basically says which customer bought which product, and how many of them.

       

      Now I want to create a pivot table:

      X-axes: Product

      Y-axes: Product

      Expression: count of customers who bought product (x-axes) AND product (y-axes).

       

      Must be simple ... I just don't see it ...

      Thanks for any hints,

      Thilo