Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)
[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] )
First time ever I beat you to an answer where we have matching expression (means my expression is not going to be wrong )