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
Email: christian.lauritzen@b3.se