2 Replies Latest reply: Jan 14, 2016 12:57 PM by Moreira Carlos RSS

    Exclude records in an object that are already displayed in another object

    Moreira Carlos

      Hello,

       

      I have a doubt and I want to know if this is possible and please forward me to another discussion or possible give me a solution (I can not find anything related to this)

       

      I'm creating two objects that both show different information (using set analysis), yet I have one condition that I can't do.

      I will explain better with an example:

      Object1:

       

      ExternalExt.ValueInternalInt.Value
      A100A'80
      B200B'100
      C50--------

       

      Object2:

       

      ExternalExt. Value
      D100
      E300
      A'80
      B'100

       

      As shown above is how it is now.

       

      What I want is to exclude from object2 the lines A' and B'. Because this documents are displayed in object1 in the Internal column.

      I just want to display in object2 the internal documents that are not related to an External Document.

       

      I know it's possible to exclude values for example using this in the calculated dimension:

       

      =aggr(only({<Type = {'*'}-{'Credit','Debit'}>} Type),Type)
      
      
      
      

       

      But as this are two different fields, I am not being able to pull this.

       

      Thanks very much.