10 Replies Latest reply: Jan 29, 2018 8:25 PM by Yi Xuan Chia RSS

    Filtering using values from another table, in expression

    Yi Xuan Chia

      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:

      customerIDInvoiceNoCustomer NameAmount$
      10011234A10
      10021235B20
      10031236C20
      10041237D30
      ............

       

      Group A table:

      A.customerIDA.Customer Name
      1001A
      1003C
      ......

       

      Group B table:

      B.customerIDB.Customer Name
      1002B
      1004D
      ......

       

      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!