Dimension Restrictions using expression

[#1]

Hi ,

Im looking to restrict my dimension to show the following:

• Always show [Care Group] that equal ' ALL CBU'
• In addition show Care Groups form the user selection list.

In the example below the result should be to show all [SECTION] that equal 'ALL CBU' and the user selection 'CBU 1 - Emergency...'.

The problem is though its only showing 'ALL CBU'.

Any ideas?

[johnw]

I'm not sure what you mean by "restrict my dimension". Like you have a chart, and you always want to show ALL CBU, and also want to show whatever the user has selected? Perhaps use set analysis on the chart expression. Like if you have an expression count(Customer), you might modify it like this:

count({<"Care Group"+={'ALL CBU'}>} Customer)