This content has been marked as final. Show 7 replies
Hi, I want to be able to create a button that when selected would set the values in a dimension.
My dimensions for selections are :
Now, I need to be able to have a button that will set the values condition as :
'State' = Concept select all values in 'Phase' ,
also if 'State' = Active then select Initiation. These selection then apply to a field 'ProjectName'.
The result would be all ProjectNames that fit either of the conditions.
Using the following if statement as an expression directly in the 'ProjectName' dimension field :
if(([Project Phase] <> 'Initiation' and [Project State] = 'Active') or ([Project State] = 'Concept'),ProjectName,Null())
produces a good list. But I need to be able to set these values using a button as there is not a good method I see to use a bookmark.
Thanks in advance!!