Exclude value from other feild

[stabben23]

Field1
10
11
12
13
14

Field2
12
13
14

Final result
10
11

Hi, i have problem to exclude values from an other field. I want to use Field1 as Dimenssion but i want to reduce the Feild with values from Field2. I do need both Fields and this is not a join issue in script. It has to be done in the layout.

[swuehl · Accepted solution]

Try something like this as dimension:

=aggr(only({<Field1 -= p(Field2) >}Field1),Field1)

[stabben23]

Thanks for fast and correct answer, use "suppress when value is null" to hide the excluded values value.