4 Replies Latest reply: Jul 18, 2012 9:23 AM by Revlin Abbi RSS

    Filtering based on value within a variable

      Hi all,

       

      Wondering if anyone has any ideas - I want to have a dimension (say field_a) within a straight table, but I only want to display the value of Field_a that matches the value in a variable x.

       

      So for example, say we have field_A with the unique values as:

       

      field_a
      -------
      a
      b
      c
      d
      e1
      e2
      etc.

       

      Variable x has value c, then I only want the straight table to show the value c.

       

      Guess I can use set analysis to solve this - within the dimension somehow, but not quite sure how. Any suggestions?

       

      Regards,

       

      Revlin