Field Name with a qualifier

[Anonymous]

I have a field name called [Anatomical Main Group].  I need to have a dimension where the [Anatomical Main Group] is restricted to one of its subgroups called [Cardiovascular System] and used as a Dimension.  What expression should i use to accomplish this?

Regards.

[sunny_talwar · Accepted solution]

Couple of ways to do this:

Use calculated dimension:

If([Anatomical Main Group] = 'Cardiovascular System', [Anatomical Main Group])

and then 'Suppress When Value Is Null' option on dimensions tab

UPDATE: you can also use Aggr function for calculated dimension:

Aggr(Only({<[Anatomical Main Group] = {'Cardiovascular System'}>} [Anatomical Main Group]), [Anatomical Main Group])

or

Use Set analysis in all your expressions:

{<[Anatomical Main Group] = {'Cardiovascular System'}>}

UPDATE:

I would suggest you to use set analysis, as calculated dimensions take more resources as per my knowledge (unless you have a lot of expressions)

[swuehl]

[Cardiovascular System] is a field value and you want [Anatomical Main Group] field to be restricted to this value?

=If( [Anatomical Main Group]  = '[Cardiovascular System]', [Anatomical Main Group] )

[sunny_talwar]

First time ever I beat you to an answer where we have matching expression (means my expression is not going to be wrong )