2 Replies Latest reply on Mar 8, 2016 5:33 AM by rohit puri

    Selecting column names using value from drop down

    rohit puri

      Hi All

       

      I am currently wanting to implement a method using which I can use a drop down populated using one table to refer to columns dynamically in another table

      For example, let us consider a table that has 2 columns and which I will use to populate the drop downs Level 1 and Level2, level 2 will hold only relevant values for selected value in level1:

      Level1Level2
      A

      A1

      AA2
      AA3
      BB1
      BB2
      CC1

      So if I select A in Level1, I will get values A1,A2,A3 in drop down. I have been able to achieve this.

       

      Suppose we make the following selection in the drop down:

       

      Level1Level2
      AA1

      Based on the above selection, now I want to refer to column "A" and column "A1" of another table in a calculated column.

      How can I achieve this, any help will be much appreciated?

      ABCA1A2A3B1B2C1VolumeValue Price
      aabbccddeeffgghhii10121.2

       

      Best

      Rohit Puri