Skip to Content
0
Jul 04, 2016 at 04:17 PM

Calculation View - Filtering Table1 where not in Table2

866 Views

Hello,

We have a requeriment where we need to filter Table1 with those records (based on the Account) that are not in Table2.

Here is an example

Table1 Table2 Result Account Value A001 100 A002 120 A003 210 A004 150 Account A002 A004 Account Value A001 100 A003 210

How do you think we can accomplish this? Is there a way to do it in a the Calculation View in Graphical mode?

Thanks, Fede