2 Replies Latest reply: Aug 17, 2011 6:31 PM by Oleg Troyansky RSS

    Filtering dimension based on another table

      I want to limit the number of records I pick up from a table to build a trellis chart. The issue I am facing is how to select a limited number of records based on a the value of the dimension in another table.

       

      I have to pick Dim1, Dim2 and Expression from Table1 while I want to display only those value of Dim1 that are available in another table Table2.

       

      Is there a way to use a calculated dimension for this?