filter a dimension depending on a prompt value

[philelmousse]

Hello I try to create a filter for a crosstab depending on a prompt value.

I created a prompt, it returns a string value. In my crosstab I created a filter like this :

CASE ?prompt?

when 'value1'
then dimensionid in ('1','2','3')
when 'value2'
then dimensionid in ('4','5','6')

But it doesnt work at all. Is it possible ?

[Lynn]

If your source is relational, you could try the expression below:

Code Select Expand


( ?prompt? = 'value1' and [dimensionid] in ('1','2','3') )
or
( ?prompt? = 'value2' and [dimensionid] in ('4','5','6') )


[philelmousse]

in the filter ?

The prompt should be in a condition. And its a DMR.