Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try something like this as dimension:
=aggr(only({<Field1 -= p(Field2) >}Field1),Field1)
Try something like this as dimension:
=aggr(only({<Field1 -= p(Field2) >}Field1),Field1)
Thanks for fast and correct answer, use "suppress when value is null" to hide the excluded values value.