7 Replies Latest reply: Jul 13, 2018 2:38 PM by Sunny Talwar RSS

    Need help with setting values using a button

    David Tate

      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  :

       

       

      StatePhase
      ActiveInitiation
      ConceptBuild
      On HoldDeliver
      CancelledClose Out

       

      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!!