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


      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