Get Sum of Value by Year in one to many relationship

[automated_user]

I have a table "Parts" that stores all information on parts in our system in a table like so:

I also have a table Called "NonConfig-PN" that tracks how many parts were bought and in what year here: 

here is the relationship between the two tables:

What I'm trying to figure out is if it is possible to get the sum of the "Pseudo" (located in NonConfig-PN table) for each "PartNum" in the Parts table for each given year, for example I'll use TS24

In the NonConfig-PN, I check the "PseudoLines" column for the given "PartNum" and then get a sum of the "Pseudo" for each given year shown here: 

So, TS24 in this example would have a sum of 4 in 2021 and a sum of 3 in 2019, 0 all other years. 

I would like this done for all parts in the Parts Table. Any help would be appreciated, as I have been stuck on this for a while now. 

Thanks.

[automated_user · Accepted solution]

After doing a little more digging, I realized that the relationship between the two tables were pointing to the wrong columns.. Once I fixed that, I was able to get my measure to work correctly.