locked
How to pull from related table RRS feed

  • Question

  • Hello. I have a lookup table with customers. In a related table I have a bunch of categories connected to those customer ids. I want to count a certain occurrence in one column for EACH customer, GIVEN the condition that another column in the non-lookup table is a certain occurrence. 

    For example count Column Paid Invoices = Free for each customer in the lookup table, GIVEN the additional condition (in the non-lookup table that another column called Status = Active. 

    Thanks!!

    Saturday, September 24, 2016 11:36 AM

Answers

  • Hi AlexMartini,

    Based on your description, I am trying to reproduce your issue in my local computer using the following three sample linked tables.


    I calculated the count for each custom in Table Custom and get the excepted results. Then get the count based on the Values is “Yes” in another column of non-lookup table Table3 as follows.




    If this is not what you want, please give us more details and sample data structure.


    Regards,
    Angelia

    Monday, September 26, 2016 7:20 AM