Calculation of a value with 2 possible outcomes

[Kevv]

I've spent a lot of time attempting to resolve this.  I hope someone can help.

I assist in providing funding to areas in the UK.  These areas overlap each other.  Where they do so the location/postcode counts as both areas.  I have 1 table that contains whether the postcode was funded, and this is linked to another table that indicates which area(s) the postcode belongs to.  Please see the example table below.

From above, the total count of A would be 4 and total count of B would be 3.  However, what I would like to show in my chart is:

A-Funded=3

A-Not Funded=1

B-Funded=2

B-Not Funded=1

Currently I can only show the values realted to Area_01 using the linked table as below.

I hope this make sense.  Any help would be very much appreciated.