13 Replies Latest reply: Mar 29, 2017 8:43 AM by Karthik Srinivasan RSS

    Showing exactly one of multiple possible values in table object

    Thorben Ortmann

      Hi,

      in a table object I want to show exactly one of multiple possible values.

      The dimension is KN_ID.

      One KN_ID can have multiple OB_ID and therefore multiple values for OB_Type. In the Table I want to show OB_Type as a measure but I do not want to do any aggregation. I just want the column OB_Type to show one of the possible values for OB_Type for KN_ID.

      So far I tried achieving that by using concat and other string functions, but I could not find a satisfying solution.

       

      Could somebody help me with that?

       

      Example is attached

       

      Best regards and thanks in advance

      thorben