1 Reply Latest reply: Mar 31, 2014 11:36 PM by Ramkumar Ramagopalan RSS

    Intersection Data to Show on Chart

    Paulus Indra Salim

      Hi,

       

      I have a question about intersection.

       

      Data example :

       

      LOAD * INLINE [

      CUSTOMER, PRODUCT

      A, Z

      A, X
      B, Z
      C, X
      D, Z

      D, X
      D, Y

      ]

       

      So this is the case, I have list box of Product and Straight Table with CUSTOMER as Dimension and Count(Product) as Expression

       

      When I Choose Product Z,

      then the table show

      CUSTOMER, Count(PRODUCT)

      A, 1

      B, 1

      D, 1

       

      When I Choose Product Z and X,

      then the table show

      CUSTOMER, Count(PRODUCT)

      A, 2

      D, 2

       

      (Because Customer A and D that bought Product Z and X)

       

      When I Choose Product Z, X and Y,

      then the table show

      CUSTOMER, Count(PRODUCT)

      D, 3

       

      (Because only Customer D that bought Product Z, X and Y)

       

      Thank you very much.