Field values that equals dimension values

[Christian_Lauritzen]

I am trying to get values from Field3 based on the values in my table dimension.

Table Dimension: Field1

Expression: = sum({<Field2=P(Field1)>} Field3) // I wish to look up field 3 values where the Field 2 values matches the current row value of Field 1

Field2: Linked with Field 1 in the data model (this link must perhaps be "disconnected" by set analysis to be able to access Field3).

Field3: The value I with to have summarized per line where Field 1 = Field 2 (Field 3 and Field 2 are in one table, Field One and Field 2 are in another)

Any ideas? Very grateful for any help!

Christian