5 Replies Latest reply: Dec 13, 2013 1:40 AM by Abhinava Chandra RSS

    Help with a pivot table

      hic,rwunderlich,mbaeyens,

       

      Hi I have a requirement where I need to create a pivot table with a Product field, which has to be used twice, both pivoted and non pivoted position.

       

      The metric that I need to calculate is a venn diagram which will calculate the number of customers which use the combinations of any two products.

       

      following is a sample of the resulting chart i need to create

      ProductABC D
      A3429
      B4863
      C26107
      D9374

       

      The data is available is Year, Quarter, Product, Country, Customer.

       

      I am facing a problem on how to segregate the values for a pair of particular product types. I tried a lot of ways to create a combination of two products, but I am not able to get the correct numbers.

      Please help.

       

      Thanks,

      Abhinava