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

    Help with a pivot table



      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


      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.