New column group by average of a reference to a related table

[Anonymous]

I have two related tables

Table A 

Group     Person

1              2

1              5

2              4

2              9

Table B 

Person    Reponse 

2               100

5                125

3                300

I would like to create a new column in Table A which is the average response for the group they are in

Table A 

Group     Person   GroupAverage

1              2              100

1              5              100

2              4               200

2              9               200

[lbendlin]

This is a standard "Filtering up"  pattern.  First you identify the parent of your element, then you calculate the result for the parent.

Are you sure you want this as a calculated column and not as a measure? Also, your expected outcome for both group1 and group 2 is not supported by Table B contents.