pivot table differentiate numbers within the same dimension

[wanyunyang]

I have a table Type:

Type

Apple

Banana

I have a table Target:

SalesArea, FoodType, Target

A                  Apple        100

A                  Banana      200

B                  Apple        150

B                  Banana      250

These two tables in my model can't be linked together, or there will be a circular reference. And I have to use Type as a dimension. So with dimension: Type, SalesArea, with measure: Target, the pivot table is like:

Which is apparently wrong. How can I show the right pivot table, which should be:

Thanks in advance for helping!!!

[sunny_talwar · Accepted solution]

May be this

Sum(If(Type = FoodType, Target))