Return value based on column contents in another table

Hello ksteever 

i just need to get understand the logic. 

in the original table, i can have many rows with the same parent , correct ? 

this means  

parent          data                 software

p1                   true                        true 

p1                   false                    false

p1                  true                        false

nowin the new table, we have unique parent values : 

parent 

p1 

when you are creating the new calculated column,  p1 is related to 3 rows, with different values, 

so the result will depend on which row ?