5 Replies Latest reply on May 3, 2018 2:14 AM by Prabu Deivendran

    Find Related Prodcuts

    Prabu Deivendran

      Hello All,


      I have an scenario to take the related product details.I have given the examples below.


      Order Details:


      For Example, We have three orders A,B and C.


      Sheet 1 Output:

      I am doing sum of quantity For the Products



      Sheet 2 Output Required:


      If i Click on the product, Respective related should show in the second sheet.


      Here I have chosen Product 1, Respective related product (Product 2,Product 3,Product 4) with quantity required in the output.

      In the below screen shot ,The Yellow color is selected product and green color will the result set(Sum of Quantity)


      Please help me on this ASAP and let me know any details required


      Thanks in advance