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 ?
If your source is relational, you could try the expression below:
( ?prompt? = 'value1' and [dimensionid] in ('1','2','3') )
or
( ?prompt? = 'value2' and [dimensionid] in ('4','5','6') )
in the filter ?
The prompt should be in a condition. And its a DMR.