Calculated Dimensions

[danielnevitt]

Hi,

I would really appreciated some help with calculated dimensions.

I have a bar graph and I would like to restrict the data to show only:

IF(MATCH(LOAD_LOC_REF,'USA','NLD','FRA'),LOAD_LOC_REF)

AND/OR

IF(MATCH(DISCH_LOC_REF,'USA',NLD','FRA'),DISCH_LOC_REF)

Both calculated dimensions work seperately, but I am unable to link them together.

Regards,

Daniel

[alexandros17 · Accepted solution]

... missing ' ...

final version

IF(MATCH(LOAD_LOC_REF,'USA','NLD','FRA'),LOAD_LOC_REF,

     IF(MATCH(DISCH_LOC_REF,'USA','NLD','FRA'),DISCH_LOC_REF,null())

)

[danielnevitt]

Hi,

Thank you very much for your help.

Regards,

Daniel