2 Replies Latest reply: Apr 6, 2018 10:59 AM by John Henry RSS

    How do I limit the values in a dimension based on another dimension?

    John Henry

      I have the following 2 dimensions:

      Column     Values

      Type          A,B,C

      Name        John, Bob, Jane, Carl, etc..

       

      Type    Name

      A          John

      A          Bob

      B          Jane

      C          Carl

       

      I would like to create a table where the first column is "Name", however, I want to limit the values in "Name" to only those where "Type" = A...how do I do that?

       

      I tried to create a derived column using a set analysis, but it requires a sum function or other operational function...here is the syntax I was using, but was not working:  =({<[Type]={'A'}>}[Name])