Not sure if I Understand but I will give it a try and hopefully this helps.
If you open the test file and press CTRL + T you will notice the two tables are not associated - No association line is present. It requires the same field names in both tables to link them up.
If you select "F" as the dimension and "sum(V)" as your expressions, the values will show up.
If you would like to create the link between the two tables:
LOAD Distinct F Resident t1;
Now press CTRL + T and see the linkage/Association.
If I have not understood your requirement, please try and explain with more detail so we can help you.