Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi Max,
Its working now, Thank you so much!