Select values of dimension to show without data selections

[kristof_j]

Hi

I want to select the values of a dimension that I want to show in a graph.

But it shouldn't make a data selection.

In other words:

A dimension has 3 values and I select 2 of them because I'm only interested in these 2.

But I don't want to make a data selectiond.

I tried with a data island but didn't find the solution.

I want to do this because the dimension in my app has many values and not all of them are relevant each time.

I can't use alternate states because I use them already in my app.

[swuehl · Accepted solution]

Try this as calculated dimension

=Aggr(Only({<Dim=Dim_select>} Dim),Dim)

and enable 'Suppress when value is NULL' on dimension tab.