7 Replies Latest reply: Feb 22, 2014 7:41 PM by Massimo Grossi RSS

    associated rows

    Mambi Badi

      Hi everyone,

      from the table below : i want to get ( in a pivot table ) only the associated products with the selected one i.e : if in my list i select 'book' -> my pivot table should display only pen and ruler with their respective quantities .

       

      orderIDproductQTY
      1book5
      1pen7
      1ruler2
      2paper10
      2pencil4
      3rubber1

       

      any idea how to do it ?