5 Replies Latest reply on Jul 27, 2016 12:44 PM by Jess Lee

    Edit Relationship Result without showing joining dimension

    Jess Lee

      hi,

       

      I'm joining 2 data sources by using edit relationship.  Column 'label' is joined between 2 sources.  As for result i would like to display 'Label Group' only and the total for 2 sources as below.  For example, Group A = 1+1+3+22=27.  Is there any way?

       

      Thank you,

       

      Result - combine between 2 data sources

        

      Label Group#
      A27
      B22
      C

      12

       

       

      Data source 1

      Label Grouplabel#
      Aa1
      Ab1
      Ad3
      Bc4
      Bc10
      Bf40
      Cg5
      Ch7

       

      Data source 2

       

      label#
      c8
      d22