Hi Alejandro,
Below is how the codes are determined for different levels in multi tier lookup table:
Let"s say I have more than 3 levels in the multi tier look and under each level I have 3 different options,
Example:
If someone selects Level One they will have to choose any of these - One, Two and Three
If someone selects Level Two they will have to choose any of these - One, Two and Three
If someone selects Level Three they will have to choose any of these - One, Two and Three
For Level One,
So while Editing the question, we type it as below,
Options will be coded as,
For Option One (4)
For Option Two(5)
For Option Three(6)
Note: I have added the codes in brackets, If the client has more options then they will be coded accordingly like if there is Option Four then then it will be coded as "7" here.
So, LevelOne will be coded as 1,
And the corresponding values/codes for One, Two and Three will be 4, 5, and 6
Note; I have also added the codes in brackets
Now for Level Two,
Level 2 will be coded as 2,
Options will be coded as,
For Option One (1)
For Option Two(2)
For Option Three(3)
Note : If the client has more options, then they will be coded accordingly like if there is an option four then it will be coded as “4” here.
Similarly for Level 3,
Level 3 will be coded as 3,
And the corresponding values/codes for One, Two and Three will be,
For Option One(7)
For Option Two(8)
For Option Three(9)
Note : If the client has more options, then they will be coded accordingly like if there is an option four then it will be coded as “10” here.
Similarly for Level 4,
Level 4 will be coded as 4,
And the corresponding values/codes for One, Two and Three will be,
For Option One(13)
For Option Two(14)
For Option Three(15)
Note : If the client has more options, then they will be coded accordingly like if there is an option four then it will be coded as "16” here.
I am sharing a screenshot of excel so you can refer the screenshot with this solution to understand this better, Screenshot = https://www.screencast.com/t/pMxPx5vfwxW