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

[#1]

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:

External	Ext.Value	Internal	Int.Value
A	100	A'	80
B	200	B'	100
C	50	----	----

Object2:

External	Ext. Value
D	100
E	300
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.

[maxgro]

if you have 2 tables

I:

load * inline [

External, Ext.Value, Internal, Int.Value

A, 100, A', 80

B, 200, B', 100

C, 50, ----, ----

];

II:

load * Inline [

Internal, Int. Value

D, 100

E, 300

A', 80

B', 100

];

you can try in a chart with Internal as dimension and this expression

sum({$ <Internal={"=count(External)=0"}>} [Int. Value])

[#3]

Hello,

thanks for your quick reply.

I'm sorry I did not explain that this data is all in the same table.

I just separate it into two objects using calculated dimensions like this:

=aggr(only({<Organization = {'123'}>} Organization),Organization)

There are more columns in this objects. I just showed this because I think these are the only ones that matter.