Filtering using values from another table, in expression

[Anonymous]

Hi all,

I currently have a main table for all my invoices, but i have 2 groups of customers, I'll name them Group A & Group B for simplicity.

I would like to do up a bar graph showing total invoice sales for these 2 group of customers.

They're all linked together by their customerID, below is a rough example of what the table structure is like(the actual tables contains thousands of customerIDs in Main invoice table, GroupA & GroupB):

Main invoice table:

customerID	InvoiceNo	Customer Name	Amount$
1001	1234	A	10
1002	1235	B	20
1003	1236	C	20
1004	1237	D	30
...	...	...	...

Group A table:

A.customerID	A.Customer Name
1001	A
1003	C
...	...

Group B table:

B.customerID	B.Customer Name
1002	B
1004	D
...	...

From my knowledge, I know that you can filter by sum({$<customerID={"1001","1003"}>} [Amount$])

But this is only practical and applicable to small tables, what I am currently working on is a table with lots of customerIDs.

Is there any way to filter by using another table's values?

Any help or comments will be greatly appreciated!

[Anonymous]

Hi Max,

Its working now, Thank you so much!